lomixture Posted November 21, 2023 Share Posted November 21, 2023 Good morning I am trying to limit the data pulled by a report to only show new inputs from the 15th Nov 2023, but I have tried a range of ways of writing the filter but nothing seems to be workng. Any tips or tricks please? Lauren Link to comment Share on other sites More sharing options...
Jim Posted November 21, 2023 Share Posted November 21, 2023 I would try against a custom criteria instead kind of like this, except with your criteria instead Link to comment Share on other sites More sharing options...
lomixture Posted November 21, 2023 Author Share Posted November 21, 2023 What's the best format to write the date, as I have above? Link to comment Share on other sites More sharing options...
Jim Posted November 21, 2023 Share Posted November 21, 2023 Actually, I think what you have works just removed the {{Date}} and right it as is in UTC format Link to comment Share on other sites More sharing options...
lomixture Posted November 22, 2023 Author Share Posted November 22, 2023 The date did work in that format, thanks Link to comment Share on other sites More sharing options...
CraigP Posted November 29, 2023 Share Posted November 29, 2023 Does anyone know what the syntax would be to put something like "6 months ago" into the custom criteria please? Link to comment Share on other sites More sharing options...
Jim Posted November 29, 2023 Share Posted November 29, 2023 h_datelogged > curdate() - INTERVAL 6 Month 1 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now