AnsweredAssumed Answered

How do you find values in a date field during the previous 2 months

Question asked by NickJaggers on Feb 28, 2014
Latest reply on Mar 4, 2014 by NickJaggers

Title

How do you find values in a date field during the previous 2 months

Post

     Hi,

      

     I have found a script which allows me to find records with a date in a Date field during the last month on the help pages, namley :

(Month (DateField) = (Month(Status(CurrentDate)) - 1) and Year (DateField) = Year(Status(CurrentDate))) or (Month (DateField) = 12 and Year (DateField) = (Year(Status(CurrentDate)) - 1)) 

     .... but how do you find records with a date in the past 2 months and take in to account dates that fall into the previous year.

     Thanks. Nick

      

      

Outcomes