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

Nick · July 26, 2018, 2:17am

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?

Tomasz · July 26, 2018, 7:15am

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

Sean · July 26, 2018, 7:33pm

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