Solved

Date Format in data import export

  • 15 March 2024
  • 2 replies
  • 36 views

Badge +2

We are upgrading from FSM 5.5 to 6U27 so a big jump. We have noticed the date format required for import export is in the form below in 6U27 with the T character.

In FSM 5.5, import export uses standard SQL date/time format.

I can work around this using the below when preparing data however is there any option to use standard date time formats in the Import Export tool? The database holds the data without the ‘T’ so strange that the import export tool uses it.

 

select product_id, CONVERT(VARCHAR(50), user_def_dttm1, 127) from product

icon

Best answer by Shneor Cheshin 18 March 2024, 04:15

View original

2 replies

Userlevel 6
Badge +26

hey @MWAMAITTEAM 

The dates are in ISO 8601 format, not sure about FSM 5.X

You can use the excel sheet for that pupose.

The basic function is: =TEXT(A1,"yyyy-mm-ddThh:MM:ss") Use this to convert your Excel date columns to separate ISO 8601 date columns. Next, copy the ISO 8601 columns onto the originals (paste special: paste values only).

Cheers!

 

Badge +2

Thanks Shneor,

This formula will be useful when preparing date imports with date/time fields.

Regards,

Barry

Reply