Jump to content
TNG Community
Rob Roy

Modified Date Search

Recommended Posts

Rob Roy

I decided to make a change in my data entry standards.  I need to create a report showing only records modified before 1 March 2020.  A list of ID, full name, and birthdate.  Been trying this with the Report Builder and failing.

Share this post


Link to post
Share on other sites
Mark

Under the Choose Criteria options you need to enter the date 2020-03-01 as a Constant String, so that it is "quoted" see attached

 

modified_date.PNG

Share this post


Link to post
Share on other sites
Rob Roy

Duh, I had put the date in as 03-01-2020.  I love simple solutions.  Thank you very much.  Now stay home and safe.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×