Discussions

 View Only
  • 1.  Formula Comparing date field to static date

    Posted 10-27-2019 22:26
    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
    ------------------------------


  • 2.  RE: Formula Comparing date field to static date

    Posted 10-28-2019 09:28
    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
    ------------------------------



  • 3.  RE: Formula Comparing date field to static date

    Posted 10-28-2019 09:52
    Thanks, Adam! <Hand hitting forehead> I tried ever combo, but that one...

    Thanks Again!

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



  • 4.  RE: Formula Comparing date field to static date

    Posted 10-28-2019 23:45
    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
    ------------------------------