Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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!