Rob Roy Posted March 16, 2020 Report Share Posted March 16, 2020 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. Quote Link to comment Share on other sites More sharing options...
Mark Posted March 19, 2020 Report Share Posted March 19, 2020 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 Quote Link to comment Share on other sites More sharing options...
Rob Roy Posted March 19, 2020 Author Report Share Posted March 19, 2020 Duh, I had put the date in as 03-01-2020. I love simple solutions. Thank you very much. Now stay home and safe. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.