Report showing all users created within the past 30 days?
Hi all. I've been tasked with creating a K1000 report that provides the name of all users created within the past 30 days. I am not a SQL gal so if anyone can help me on this it would be greatly appreciated!
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
chucksteel
5 years ago
Top Answer
Here you go:
SELECT USER_NAME, EMAIL, FULL_NAME, CREATED FROM ORG1.USER
WHERE CREATED > DATE_SUB(NOW(), INTERVAL 1 MONTH);
If there are other fields required for your report let me know.
Comments:
-
...you ROCK!! Thank you chucksteel!! - auntie4life 5 years ago
