In each record I have two date fields (retirementdate and separationdate). In the record one of the date fields will have a date. The other field will be left blank.
I want to combine the two date fields into one field (combineddate) then sort the data (ascending). I created a new field. The dates show correctly but the data doesn't sort correctly.
CombinedDate: [RetirementDate] & [SeparationDate]
Thinking my problem may be format related, I modified the field to read:
CombinedDate: Format([RetirementDate] & [SeparationDate],"dd mmm yy")
Again the dates show correctly but I cannot sort the data (ascending).
What am I doing wrong? Thanks
I want to combine the two date fields into one field (combineddate) then sort the data (ascending). I created a new field. The dates show correctly but the data doesn't sort correctly.
CombinedDate: [RetirementDate] & [SeparationDate]
Thinking my problem may be format related, I modified the field to read:
CombinedDate: Format([RetirementDate] & [SeparationDate],"dd mmm yy")
Again the dates show correctly but I cannot sort the data (ascending).
What am I doing wrong? Thanks