AnsweredAssumed Answered

If function involving date ranges

Question asked by JenC on Aug 4, 2013
Latest reply on Aug 6, 2013 by philmodjunk


If function involving date ranges


     In my first ever Filemaker Pro DB, I have a number of fields including Date and Financial Year. As I am importing a large number of records, I wanted the Financial Year field to automatically fill, depending on the record date.

     To achieve this, I decided to use the If function, specifically:

     If (Date < 1/7/2013 ; " July '12 - June '13" ; "July '13 - June '14" )

     However, all records, regardless of date, are returning "July '13 - June '14". I suspect that my use of "< 1/7/2013" to represent dates before 1 July 2013 is the problem.

     Can anyone help?