Output date in XML format

[mdlr]

Thanks, to Phil's help (https://exiftool.org/forum/index.php/topic,9103.0.html), I am now able to extract the date in which the image was last modified, among others, using the following:

Code Select Expand

exiftool -echo "SourceFile,FileName,ImageWidth,ImageHeight,FileModifyDate" -r -p "/$directory/$filename,$filename,$imagewidth,$imageheight,$filemodifydate" assets/photo > _data/images.csv

I am trying to figure out how to format the date so that it outputs in XML format; e.g. 2018-04-21T07:59:12-07:00

Thanks in advance for any guidance.

[StarGeek]

You can change the date format with the -d option.  Also check the Filename and Directory page for various date codes.

[mdlr]

You can change the date format with the -d option.  Also check the Filename and Directory page for various date codes.

Thank you. However, I am having a hard time figuring out the syntax. Here's what I have tried:

Code Select Expand

exiftool -echo "SourceFile,FileName,ImageWidth,ImageHeight,FileModifyDate" -r -p -d %Y-%m-%dT%H:%M:%S-%z  "/$directory/$filename,$filename,$imagewidth,$imageheight,$filemodifydate" assets/photo > _data/images.csv

This gives me a file not found error for "%Y-%m-%dT%H:%M:%S-%z"

I'm also not sure how to add the T between date and time.

[StarGeek]

You inserted the -d %Y-%m-%dT%H:%M:%S-%z in between the -p and the format for that option.  Put it before the -p or after the format string and it should work.  And I don't think you need the dash before the %z, as it should be included, since technically it can also be a plus sign there as well.

[mdlr]

You inserted the -d %Y-%m-%dT%H:%M:%S-%z in between the -p and the format for that option.  Put it before the -p or after the format string and it should work.  And I don't think you need the dash before the %z, as it should be included, since technically it can also be a plus sign there as well.

That did the trick. Thank you!