ajayz

Help with (Month(Status(CurrentDate)) - 1)

Discussion created by ajayz on Mar 4, 2013
Latest reply on Mar 4, 2013 by ErikWegweiser

I'm trying to use the following formula:

 

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

 

 

My Database date field is actually called [Date] which I've plugged into the formular which should give Last Month's Records

 

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

 

When I save the forumlar I get "This function cannot be found" referring to STATUS i.e (Month(Status(CurrentDate))

 

I'm using FileMaker Po Advance 12.

Outcomes