QQ - Can I load DateTime data in format DD/MM/YYYY HH:SS?
  • 1 Minute to read
  • Dark
    Light
  • PDF

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

  • Dark
    Light
  • PDF

Article summary

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



Was this article helpful?