Alisha Posted January 3 Share Posted January 3 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 Share Posted January 3 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 Author Share Posted January 3 Thank you @Steve Giller! Using Between worked! Link to comment Share on other sites More sharing options...
Alisha Posted January 3 Author Share Posted January 3 @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 Share Posted January 3 Are you overthinking this? 1 Link to comment Share on other sites More sharing options...
Alisha Posted January 3 Author Share Posted January 3 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