Date-time formats supported in Control Compliance Suite for importing external data

CCS supports the following date-time formats while importing external data.
For example if the date is 6th January 2012, and the time is 05 hrs 10 minutes and 32 seconds (24 hour clock):
  • yyyy/MM/dd
    For example, 2012/01/06
  • dd.MM.YYYY
    For example, 06.01.2012
  • M/d/yyyy
    For example, 1/6/2012
  • d-M-yyyy
    For example, 6-1-2012
  • dd/MM/yyyy
    For example, 06/01/2012
  • yyyy-MM-ddThh:mm:ssZ
    For example, 2012-01-06T05:10:32Z
  • M/d/yyyy h:mm:ss tt
    For example, 1/6/2012 5:10:32 AM
  • yyyy-MM-dd tt h:mm:ss
    For example, 2012-01-06 AM 5:10:32
  • yyyy-MM-dd HH:mm:ss
    For example, 2012-01-06 05:10:32
  • yyyy-MM-dd HH:mm:ss.fff
    For example, 2012-01-06 05:10:32.600
  • yyyy/MM/dd hh:mm:ss tt
    For example, 2012/01/06 05:10:32 AM
  • yyyy/M/d HH:mm:ss
    For example, 2012/1/6 05:10:32
  • yyyy-M-d H:mm:ss
    For example, 2012-1-6 5:10:32
  • d-M-yyyy H:mm:ss
    For example, 6-1-2012 5:10:32
  • dd/MM/yyyy hh:mm:ss tt
    For example, 06/01/2012 05:10:32 AM
  • dd/MM/yyyy HH:mm:ss
    For example, 06/01/2012 05:10:32
  • dd/MM/yyyy h:mm:ss tt
    For example, 06/01/2012 5:10:32 AM
  • dd.MM.yyyy H:mm:ss
    For example, 06.01.2012 5:10:32
  • d/MM/yyyy h:mm:ss tt
    For example, 6/01/2012 5:10:32 AM
  • d/MM/yyyy H:mm:ss
    For example, 6/01/2012 5:10:32
  • d/M/yyyy tt h:mm:ss
    For example, 6/1/2012 AM 5:10:32
  • dd-MMM-yyyy
    For example, 06-Jan-2012
  • dd-MMM-yyyy hh:mm:ss tt
    For example, 06-Jan-2012 05:10:32 AM
  • M/d/yyyy hh:mm:ss tt
    For example, 1/6/2012 05:10:32 AM