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 [Date Field] <= 11/12/2019, true

Thank You!

------------------------------
Chris
------------------------------
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
      ------------------------------
  • BabiPanjikar's avatar
    BabiPanjikar
    Qrew Assistant Captain
    6 years ago
    If ([Date Field] >= ToDate("10/18/2019") and [Date Field] <= ToDate("11/12/2019", true,false)

    If your [Date Field] is with date time, then you need to convert that to date format using ToDate() function.

    ------------------------------
    Babi Panjikar
    ------------------------------