Datetime Formula Help
Hello, I am attempting to set up a formula in Advanced Table Settings, that would generate a warning message if [Lease Processed], a DateTime field, was accidentally entered with a date outside of th...
Forum Discussion
Hi Liz,
You probably want to use a formula like:
If(Year(ToDate([Your DateTime Field Here])) <> Year(Today()), "Your Warning Message Here")
This will check to see if your DateTime field is not equal to the current year and if it is not then they should get the warning message you set up. I hope that is helpful Liz.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
You probably want to use a formula like:
If(Year(ToDate([Your DateTime Field Here])) <> Year(Today()), "Your Warning Message Here")
This will check to see if your DateTime field is not equal to the current year and if it is not then they should get the warning message you set up. I hope that is helpful Liz.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
- Ack, I was so close! Thank you Evan, this works!
------------------------------
Liz Chartrand
------------------------------
