QQ - Can I load DateTime data in format DD/MM/YYYY HH:SS?

  • 1 minute(s) read

Yes - use the CreateTableFromFile method, and set the default dateTimeFormat to be:

"dateTimeFormat": "DD-MM-YYYY HH:MM",

Date and DateTime formats
DataJet will recognise any separator in Date or DateTime fields, so long as the separator used is consistent.
For example, DD-MM-YYYY is a valid format for DD/MM/YYYY,  DD MM YYYY, DD|MM|YYYY etc