How to run an exploration with custom format in date/time column

Quick question. Say we have this:

SetOption( "NoDefaultColumns", True );
AddColumn( DateTime(), "Date/Time", formatDateTime);

A batch file is exporting the exploration to a csv with the date/time column in this format:
7/18/2018 5:00:00 PM

and we want it to use this format:
7/18/2018 17:00


The format code, if I'm not mistaken is: "%m/%d/%Y %H:%M"

How do we do it?

No, it uses Windows Settings. So go to Windows Control Panel, Regional Settings and change short date format there.

1 Like

Just a quick FYI. If you need to or will sort ASCII at any point YYYYmmdd is the best.