1 Reply Latest reply: Aug 20, 2012 12:45 PM by Michael Solomovich RSS

    Does my date fall within a range?

    Chris McCafferty


      Hi Guys,


      I was hoping someone could help me.

      Im trying to return a series of results whereby a holiday is currently going on, (ie: today's date is in between the Departure Date and the Return Date).


      I dont have a database field for "Return Date" so I calculated this using the formula:  [Departure Date]+[TD Duration]


      Can you tell me whether or not my formula below makes sense:



      = if ( [Departure Date] <today() ,if( ( [Departure Date] + [TD Duration] ) >today() , "Yes" , "No" ) , "No" )



      Many thanks