QQ - Can I load DateTime data in format DD/MM/YYYY HH:SS?
- 1 Minute to read
- Print
- DarkLight
- PDF
QQ - Can I load DateTime data in format DD/MM/YYYY HH:SS?
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
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
For example, DD-MM-YYYY is a valid format for DD/MM/YYYY, DD MM YYYY, DD|MM|YYYY etc
Was this article helpful?