Formatting date time for output to a csv file

[d50034-furious]

I've got to the stage where I'm able to output to a csv file to eventually put into an Access database. However, I'm having difficulties with formatting a date. I'm using an args file, but it's not obvious to me where and how the -d '%d-%m-%Y %H:%M:%S' format goes. I've tried running the exiftool function as

Code Select Expand

exiftool -d '%d-%m-%Y %H:%M:%S' -DateTimeOriginal *.jpg
This gives the date without time and says one file couldn't be processed, yet everything I've seen says to put single quotes around the format as it has the space.
Here are some of the lines from my args file

Code Select Expand

-EXIF:Artist
-EXIF:copyright
-d '%d-%m-%Y %H:%M:%S'
-EXIF:DateTimeOriginal
-XMP:Description
-EXIF:ExposureTimeWhat am I doing wrong?
Malcolm

[StarGeek]

This is FAQ #29, "My options don't work in a -@ ARGFILE".

You would use

Code Select Expand

-d
%d-%m-%Y %H:%M:%S
Separate lines, no quotes, no trailing spaces.

[d50034-furious]

I tried that and it still threw a wobbly - then I noticed a space after -DateTimeOriginal, removed that and now it works. Something to be aware of. Now to seeing about importing into Access!
Is there a thanks button on this forum? If not then 'Thanks!'
Malcolm