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?