Metadata Date Field and Keyword Modifiers

(D Langlands) #1

Hi folks


A Metadata mystery for you.



I have a bunch of Metadata Data Fields that I want to transform them from their standard format: 29/04/2012 00:09:15 to something friendlier like 29 April 2012, 9:15am.



Let's just start with the year.



I've tried using both %globals_asset_metadata_coursestartdate1^date_format:Y% and %asset_metadata_coursestartdate1^date_format:Y% but the year always appears as 1970 - which is the default setting but even when I've checked and changed the year to 2012 still it is always the same.



Is there another way of transforming the metadata date field?



Thanks in advance



Darren

(D Langlands) #2

Also tried both %globals_asset_metadata_coursestartdate1_Y% and %asset_metadata_coursestartdate1_Y% to no avail. These don't display anything.

(D Langlands) #3

Used this in the display format field of the metadata schema and it worked: j F Y, ga


Still interested if you can do any transformation using keyword modifiers however?

(Aleks Bochniak) #4

Does this work?

    %asset_metadata_coursestartdate1^date_format:j F Y, ga%
(Mohamed Haidar) #5

Unfortunately this issue keeps coming up. The date_format keyword modifier does not support this date format (29/04/2012 00:09:15)…
It needs to be in this format (29-04-2012 00:09:15). You would need to change the metadata date field format.

(Anewport) #6

We had the same issue come up today - glad to see that the thread was already started :slight_smile:

[quote]

Unfortunately this issue keeps coming up. The date_format keyword modifier does not support this date format (29/04/2012 00:09:15)…

It needs to be in this format (29-04-2012 00:09:15). You would need to change the metadata date field format.

[/quote]



Thanks Mohamed, your solution has worked fine for us. Are there any plans in the future to have a date schema field created with the hyphens instead of slashes?

(D Langlands) #7

Yes, thanks also - changing the metadata date field display format to d-g-Y H:i:s allows you then to use keyword modifiers on that field throughout.


Squiz peeps, is this one in roadmap? Be useful if the default format was the same as above.

(D Langlands) #8

Sorry that format is j-m-Y H:i:s

(Aleks Bochniak) #9

I've encountered this stumbling block too… grrr