Search

Formulas - How to change the date/time format?

Svitlana Zh.
Svitlana Zh.
  • Updated

You can change the date/time format using one of the following functions:

  • DATE >> CHANGE DATETIME FORMAT
  • DATE >> FORMAT DATE

Image

1. Match the Field section with the field that contains the date and/or time information
2. In the Input Format you should specify the date/time format received by LeadsBridge from the Source application
3. While in the Output Format type the new format that will be synced to your Destination integration

You can use the following sets of Format:

  • Y for the Year with 4 digits (e.g. “2023”), y for the Year in 2 digits (e.g. “23”)
  • M for the Month with 3 chars (e.g. “Jan”, “Feb”), m for the month with 2 digits (e.g. “01”, “02”)
  • D for the Day with 3 chars (e.g. “Mon”, “Tue”), d for the Day with 2 digits (e.g. “23”)
  • H for the Hours 0-24, h for the Hours 0-12
  • i for the Minutes in 2 digits
  • s for the Second in 2 digits

For example, if you’re receiving the Date/Time in 08-01-2023 from your Source integration. By assigning the FORMAT DATE function with Y-m-d, you’ll receive the value 2023-01-08 in your Destination integration.

Additional Note: LeadsBridge converts the received Date/Time into the UNIX format by default.

Image

Otherwise, if you want to change the date/time format in the entire account and bridges, refer to the article on how to customize your LeadsBridge account timezone and date format.

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.