Alisha Posted January 3, 2023 Share Posted January 3, 2023 Good morning and Happy New Year, I'm trying to create a report to show upcoming Changes within a certain timeframe, e.g. today and the next 2 days. However, I'm not sure what criteria to use. I have tried the below but this doesn't seem to work. Any assistance would be much appreciated. Many thanks, Alisha Link to comment Share on other sites More sharing options...
Steve Giller Posted January 3, 2023 Share Posted January 3, 2023 You probably need to use the BETWEEN comparison here, equals will only give you changes scheduled for that exact second. This webpage may be a good place to start. 1 Link to comment Share on other sites More sharing options...
Alisha Posted January 3, 2023 Author Share Posted January 3, 2023 Thank you @Steve Giller! Using Between worked! Link to comment Share on other sites More sharing options...
Alisha Posted January 3, 2023 Author Share Posted January 3, 2023 @Steve Giller Just realised that we would still like to see the Changes scheduled today, even if the Start Time has passed, as well as the Changes scheduled for tomorrow. Is that possible please? Link to comment Share on other sites More sharing options...
Steve Giller Posted January 3, 2023 Share Posted January 3, 2023 Are you overthinking this? 1 Link to comment Share on other sites More sharing options...
Alisha Posted January 3, 2023 Author Share Posted January 3, 2023 Um, yes, I must have been! Thank you! 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