by Barry4679 » Sun Mar 24, 2024 9:03 pm
Hellscaretaker wrote: ↑Sat Mar 23, 2024 5:40 pm
Regarding the Date field.
I'm using this format
17/11/2003 for Now 56
22/07/2003 for Now 55
Just to add I'm using the UK format of Date.
What is the "for Now xx" suffix that you are appending to the date?
It looks MM is not recognising your "dates" as being calendar dates. ... because they have not been recorded in a generally recognised date format. It is sorting the column alphabetically, ie "17" comes before "22"
If the "for Now xx" values are meaningful for you for grouping or filter purposes, you should put those values in one of the Custom tags.
I don't think that MM has custom settings for date format. I think that they get the date format from where you have configured your geographic region in Windows. If your PC is configured to be in a region that uses day/month/year date format MM will OK with UK date format.
[quote=Hellscaretaker post_id=518127 time=1711233626 user_id=120169]
Regarding the Date field.
I'm using this format
17/11/2003 for Now 56
22/07/2003 for Now 55
Just to add I'm using the UK format of Date.
[/quote]
What is the "for Now xx" suffix that you are appending to the date?
It looks MM is not recognising your "dates" as being calendar dates. ... because they have not been recorded in a generally recognised date format. It is sorting the column alphabetically, ie "17" comes before "22"
If the "for Now xx" values are meaningful for you for grouping or filter purposes, you should put those values in one of the Custom tags.
I don't think that MM has custom settings for date format. I think that they get the date format from where you have configured your geographic region in Windows. If your PC is configured to be in a region that uses day/month/year date format MM will OK with UK date format.