Table of Contents

Search

  1. Preface
  2. Introduction to Informatica MDM - Customer 360
  3. Getting Started
  4. Adding Records
  5. Working with Draft Records
  6. Finding Records
  7. Editing Records
  8. Managing Record Versions
  9. Importing Bulk Data
  10. Viewing Tasks
  11. Participating in Review Processes
  12. Managing Tasks
  13. Resolving Duplicates
  14. Investigating Data Changes
  15. Investigating Relationships
  16. Creating Customer Profiles on the Customer Portal

Supported Date Patterns

Supported Date Patterns

When you import data, if the date values do not match with the supported date patterns, the import process fails.
The following table lists all the date patterns that the import process supports:
yyyy-MM-dd'T'HH:mm:ss.SSS'Z'
d/M/yy h:mm:ss a
d/M/yyyy H:mm:ss
yyyy/M/d
d/M/yy h:mm:ss a z
d/M/yyyy H:mm:ss z
yyyy/M/d h:mm
d/M/yy h:mm a
d-MMM-yy
yyyy/M/d h:mm:ss
d/M/yy h:mm:ss a
d-MMM-yy h:mm a
yyyy/M/d h:mm a
d/M/yy h:mm:ss a z
d-MMM-yy h:mm:ss a
yyyy/M/d h:mm:ss a
d/M/yyyy
d-MMM-yy h:mm:ss z a
yyyy/M/d H:mm
d/M/yyyy h:mm a
d-MMM-yy
yyyy/M/d H:mm:ss
d/M/yyyy h:mm:ss a
d-MMM-yy HH:mm
d/M/yy
d/M/yyyy h:mm:ss a z
d-MMM-yy HH:mm:ss
d/M/yy h:mm a
d/M/yyyy H:mm
d-MMM-yy HH:mm:ss z
d MMMM, yyyy
d MMMM, yyyy h:mm a
d MMMM, yyyy h:mm:ss a
d MMMM yyyy h:mm a
d MMMM yyyy h:mm:ss a
d MMMM yyyy h:mm:ss a z
d MMM yyyy h:mm:ss a
d MMM yyyy HH:mm
d MMM yyyy HH:mm:ss
d MMMM yyyy h:mm a
d MMMM yyyy h:mm:ss a
d MMMM yyyy HH:mm
M/d/yy
M/d/yy h:mm a
M/d/yy h:mm:ss a
M/d/yyyy h:mm a
M/d/yyyy h:mm:ss a
M/d/yyyy h:mm:ss a z
M d, yy h:mm:ss a z
M d, yy h:mm:ss a
MMM d, yyyy
MMM d, yyyy h:mm:ss a z
MMMM d, yyyy
MMMM d, yyyy h:mm a
MMMM d, yyyy h:mm:ss a z
dd-MM-yyyy h:mm:ss z a
dd-MM-yyyy
dd-MM-yyyy h:mm:ss a
dd-MM-yyyy HH:mm:ss
dd-MM-yyyy HH:mm:ss z
d MMM, yyyy h:mm a
d MMM, yyyy h:mm:ss a
d MMM, yyyy h:mm:ss a z
d MMMM yyyy
d MMMM yyyy HH:mm:ss z
M/d/yyyy
MMM d, yyyy h:mm:ss a
MMMM d, yyyy h:mm:ss z a
d-MMM-yyyy h:mm:ss a
d-MMM-yyyy
d-MMM-yyyy h:mm a
d-MMM-yyyy h:mm:ss z a
d-MMM-yyyy h:mm:ss z a
d-MMM-yyyy
d-MMM-yyyy HH:mm
d-MMM-yyyy HH:mm:ss
d-MMM-yyyy HH:mm:ss z
dd-MM-yyyy
dd-MM-yyyy h:mm a
d MMMM, yyyy h:mm:ss a z
d MMM yyyy
d MMM yyyy HH:mm:ss z
d MMMM yyyy HH:mm:ss
M/d/yy h:mm:ss a z
M d, yy
MMM d, yyyy h:mm a
MMMM d, yyyy h:mm:ss
dd-MM-yyyy HH:mm
d MMM, yyyy
d MMMM yyyy
M d, yy h:mm a
.

0 COMMENTS

We’d like to hear from you!