/build/static/layout/Breadcrumb_cap_w.png
06/02/2019 193 views

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!

Answer Summary:
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

0

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.


Answered 06/03/2019 by: chucksteel
Red Belt

  • ...you ROCK!! Thank you chucksteel!!