3 Replies Latest reply on Mar 13, 2015 9:47 PM by philmodjunk

    Creating Summaries by Month and format of displayed date

    MichaelCotterill_1

      Title

      Creating Summaries by Month and format of displayed date

      Post

      On Filemaker Pro 13 I have created a data base counting bird numbers at the airport I manage. The data collected represents species, zones sighted, activity, attractants, harassments and results of harassments. This data is collected live in the field using Filemaker Go.

       Each data entry has an associated date, which is currently in the dd/mm/yyyy format.

      I have created a Year Month field by using

      Year(Date) & " " & Right("00" & Month(Date);2)

      and my summary fields for reports sorts using this field. The reports and summaries produced are correct for each month but the appearance of the report is not the desired look.

      My problem is the Year Month representation  generated appears as 2015 03 (for example representing March 2015), where I would like it to appear (using the same example) as March 2015.

      Any help greatly appreciated.

      Cheers

      Hossdog