2 Replies Latest reply on Mar 4, 2013 3:52 PM by ErikWegweiser

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

    ajayz

      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.