AnsweredAssumed Answered

date range

Question asked by TorbenPoulsen on May 26, 2013
Latest reply on May 26, 2013 by TorbenPoulsen


date range



     i would like some help with finding records within date range.
     I would like to check if date field is within last 6 months from todays date. If true set check field to 1 or of false set field to 0.
     I have tried with IF and Case but it seams like they dont work with range.
     my calculation looks like this:
     Case (record checked=GetAsText(Get( CurrentDate ) - 183 ) & "..." & GetAsText(Get( CurrentDate ) - 1 );1;0)
     But it always return 0
     What do i do wrong