KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
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
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

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.