When setting a metadata date value manually the format must be:
But when using the keyword replacement of the metadata date it comes in the format of:
DD MMM YY
This has created an issue for me when I would like to base another metadata date value off the original. An example of this would be using a trigger to add an archive date for an asset based on a metadata value.
Using ‘Set Future Status’ this can be done, but I also wanted to have an email go out on the archive date.
The way I have solved this is with the use of the ‘Set Metadata Value’ action, using a metadata keyword and formatting it to the appropriate format.
I think it would be nice to have some documentation of what is required to use ‘Set Metadata Value’ for different metadata types as I just guessed with this based on the JSON API documentation.
Really just posting this here so others can refer to it.