AnsweredAssumed Answered

date range

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

Title

date range

Post

      

     Hi
     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

Outcomes