Matrix stumbling over date format

I'm trying to display a date metadata field using the following:


%asset_metadata_Date^date_format:j F Y%



Except Matrix keeps trying to put the date's month under j and the day under F.



Dates in my Matrix system should all be in day/month/year format, but the date_format keyword modifier seems to assume it is month/day/year.

[quote]
I'm trying to display a date metadata field using the following:



%asset_metadata_Date^date_format:j F Y%



Except Matrix keeps trying to put the date's month under j and the day under F.



Dates in my Matrix system should all be in day/month/year format, but the date_format keyword modifier seems to assume it is month/day/year.

[/quote]



This is actually PHP confusing the dates, see the function Matrix uses can only really "guess" at whether its European (dd/mm/yy) or American (mm/dd/yy) when it is in that format, so it recommends using yyyy-mm-dd (which is the ISO format).



Having said that, you should be able to work around this issue by using:

    %asset_metadata_Date^replace:\/:-^date_format:j F Y%


As the PHP function assumes xx/xx/xx as American and xx-xx-xx as European

Hope that helps