Forum Discussion

ChrisFaye1's avatar
ChrisFaye1
Qrew Cadet
6 years ago

Formula Comparing date field to static date

This is probably a really simple solve. I'm running into trouble using a static date in a formula. What would be the best way to write a formula that says,  If [Date Field] >= 10/18/2019 and [D...
Formulas and functions
AdamKeever1's avatar
AdamKeever1
Qrew Commander
6 years ago
Using a formula rich text field, try this:

If ([Date Field] >= ToDate("10/18/2019") and [Date Field] <= ToDate("11/12/2019"),"True",null)​


------------------------------
Adam Keever
------------------------------
ChrisFaye1's avatar
ChrisFaye1
Qrew Cadet
6 years ago
Thanks, Adam! <Hand hitting forehead> I tried ever combo, but that one...

Thanks Again!

------------------------------
Chris
------------------------------