Mapping Date and Time Fields for Produced Data Imports

Mapping Date/Time Metadata Fields in Load Files

If your production's load file contains metadata fields with date/time information, it is important to ensure these values are mapped correctly for accurate metadata loading.

The following fields have specific date/time formatting requirements:

• Email Sent
• Email Received
• Created Date Time
• Modified Date Time
• Last Print Time

There are two scenarios to consider when mapping these fields:

Scenario 1: Combined Date and Time in One Column

If the values are in a single column formatted as:

• mm/dd/yyyy hh:mm
• mm/dd/yyyy hh:mm:ss
• mm/dd/yyyy hh:mm AM/PM
• mm/dd/yyyy hh:mm:ss AM/PM

Then map directly to:

• Email Sent
• Email Received
• Created Date Time
• Modified Date Time
• Last Print Time

Scenario 2: Date and Time in Separate Columns

If the values are split into two columns:

• one for the date:mm/dd/yyyy 
• one for the time:
  • hh:mm
  • hh:mm:ssh
  • h:mm AM/PM
  • hh:mm:ss AM/PM

Then map the following field pairs:

• Email Sent Date → Email Sent Time
• Email Received Date → Email Received Time
• Created Date Time Date → Created Date Time Time
• Modified Date Time Date → Modified Date Time Time
• Last Print Date → Last Print Time

Proper mapping ensures accurate processing and display of metadata during review and production.