Tech Tip: Importing and exporting date and time data using the Import/Export Editor
PRODUCT: 4D | VERSION: 2003 | PLATFORM: Mac & Win
Published On: May 30, 2003
A new display format is available for importing and exporting date and time data.
This format corresponds to the XML date and time representation standard, which would note the date and time May 31, 2003 at 1:20 PM as 2003-05-31T13:20:00.
Though 4th Dimensions does not store date and time data in a single field, you can use the format in the following ways:
- Data exported from a 4th Dimension date field, will be represented as follows: May 31, 2003 would be 2003-05-31T00:00:00
- Data exported from a 4th Dimension time field, will be represented as follows: 1:20 PM would be 0000-00-00T13:20:00
- XML data can be imported into either a 4th Dimension date or time field.