function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
kim_lebiczkim_lebicz 

Formula Field Help

Hello All
 
I know this should be easy but I am stumped. I am trying to write a formula that says:
 
If MyDate field < Today and is not null, "True", "False"
 
Any help would be appreciated!
TCAdminTCAdmin
Hello kim_lebicz,

This should get you going in the right direction.  Please let me know if you have issues with it.

Code:
IF(AND(LEN(MyDate) > 0, MyDate < TODAY()), "True", "False")

kim_lebiczkim_lebicz
Thanks so much!