Skip to Content

Format for time in C4C migration tool

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 24, 2017 at 01:51 PM

    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.

    Add comment
    10|10000 characters needed 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