Importing date/time values

  • Release version: Zurich
  • Updated July 31, 2025
  • 1 minute to read

    • Considerations when importing data containing date/time values.

    • The field containing the date/time value should be a Date/Time type field in the target table.
    • The user performing the import should have their timezone (in the Time zone [time_zone] field in the User [sys_user] record for that user) set to match the timezone of the date/time values in the import file.
      To set the user timezone, do the following.
      1. Click the user drop-down in the banner and select Profile.
      2. Change the Time zone field value to the timezone of the date/time values in the import file and click Update.