Question:
How can I convert a XML date with a macro?
Answer:
When using XML index files, you may occasionally come across date values like 2018-08-02T13:45:32.123+01:00
Even though the processing was implemented using the Convert Date and Format macro during the beta phase, you can find a macro here that you can use to implement this yourself. A technical demo of the Scriptengine, so to speak.
outformat = “dd.MM.yyyy HH:mm:ss”
informat = “yyyy-MM-ddTHH:mm:ss.fffK”
from System import DateTime
from System.Globalization import CultureInfo
dt = DateTime.ParseExact(in_value, informat, CultureInfo.InvariantCulture)
return dt.ToString(outformat)