If date range falls within certain date range formula help

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Hello,

How can I write this on QB and what is the field type I should select?

if([start date] > 1/1/2015 AND [end date] < 1/31/2015, [$ value], blank)

Thanks

Photo of ayden

ayden

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,004 Points 20k badge 2x thumb
Try this:

If([start date] > Date(2000,1,10) and [end date] < Date(2015,1,31) ,
  [$ value]
)

Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,004 Points 20k badge 2x thumb
Try this:

If([start date] > Date(2000,1,10) and [end date] < Date(2015,1,31) ,
  [$ value]
)

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,096 Points 50k badge 2x thumb
If you wanted a formula to self adjust to flag records which are during the current year, you can do this

If([start date] >= Date(Year(Today()),1,1) and [end date] <= Date(Year(Today()),1,31) ,
  [$ value]
)