Skip to main content
Solved

Date Format in data import export


Forum|alt.badge.img+7

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

Best answer by Shneor Cheshin

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!

 

View original
Did this topic help you find an answer to your question?

2 replies

Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • 1139 replies
  • Answer
  • March 18, 2024

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!

 


Forum|alt.badge.img+7
  • Author
  • Sidekick (Customer)
  • 26 replies
  • March 25, 2024

Thanks Shneor,

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

Regards,

Barry


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings