I have a field which I want to automatically have text after a certain date (which is in my Date field). So if its after 01 August 2021 the field will say “Hello World” (or somesuch!). For records before this date, the field will remain blank.
So something like
IF ( [DATE]
< DATEVALUE("2021-07-01"; "yyyy-MM-dd") “Hello World”; “”)
But that’s not working for me. Any clues?
This topic was modified 3 months ago by David Gordon. Reason: Typo