Easily Change Date Formats in Bulk

Hi there,

We’ve added two date formatting options to the Transform Data module, letting you easily change date formats in both date fields and text or string fields to ensure consistency with other values in your database or maintain compatibility with other systems.

• Format: Date/Timestamp to MM-DD-YYYY
• Format: Date/Timestamp to DD-MM-YYYY

For example, if I have a ‘Contact Close Date’ field with dates like 2/10/21, I could use the ‘Format: Date/Timestamp to MM-DD-YYYY’ function to convert it to 10-02-2021.

Or, suppose I have an ‘Account Create Date’ timestamp value of “2024-05-07T01:09:30.273Z.” I can reformat this using the ‘Format: Date/Timestamp to DD-MM-YYYY’ option so it would be 05-07-2024.

Learn more in the Format: Ensure Data is Formatted Correctly section of the Transform Data Function Catalog.