Skip to Content
0

Format for time in C4C migration tool

May 23, 2017 at 02:41 PM

73

avatar image

Hi,

We have a field defined as Type Time using the Key User Tool. What format should we use?

We have tried the following formats and they did not work.

HH:MM:SS

YYYY-MM-DDTHH:MM:SSZ

Thanks

Edmund

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Norbert Naros
May 24, 2017 at 01:51 PM
0

Dear Edmund,

The valid ISO code date format is : YYYY-MM-DDT00:00:00Z.

Please try this format and let me know the outcome.

Thanks,

Norbert.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Norbert,

Thanks for your reply. I need the time format, as the data type is Time.

I have tried formats like:

HH:MM:SS eg 17:34:05

and YYYY-MM-DDTHH:MM:SSZ but it did not work.

Thanks for your help.

Edmund

0