Joanne Rickwood Posted February 2, 2021 Share Posted February 2, 2021 I want a flag that essentially says if a field is not populated by a particular date (crude terminology) i.e. if day6 = today and field X is blank then "BAD" else "GOOD" but I only want it to happen when day6 is today, and then whatever the answer is it won't change so regardless of whether field X is populated on day7 or day 50, if it was blank on day6 it stays "BAD" Link to comment Share on other sites More sharing options...
Gaia Paolini Posted February 3, 2021 Share Posted February 3, 2021 If you ask the question every day, today (the cutoff date) keeps shifting. Can you elaborate on the requirements Is today a way of expressing a number of days from some initial date Link to comment Share on other sites More sharing options...
Kirsten Smith Posted February 3, 2021 Share Posted February 3, 2021 The DateTimeNow() function should work in your case() statement to get this result 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