Skip to main content
Question

Formula Comparing date field to static date

  • October 28, 2019
  • 0 replies
  • 107 views
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
------------------------------
This topic has been closed for replies.

AdamKeever1
Forum|alt.badge.img+2
  • AdamKeever1
  • Quickbase Alumni
  • October 28, 2019
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
------------------------------
  • BabiPanjikar
  • Quickbase Alumni
  • October 29, 2019
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
------------------------------
Terms & ConditionsAccessibility statement