Guide to Format Dates inside of Messages

If you are using date data type in a lead data field. You can consider using the following format short codes to format and display a dynamic date and time in your message.

For example if you have a lead data field called [appointment_date] which is of date data type and you write it in your chat message it would look like the following.

Dear Customer, 
Your appointment has been confirmed on [appointment_date].

Outcome

Dear Customer, 
Your appointment has been confirmed on 2023-11-06t00:00:00.000.

The outcome is un-formatted and looks rather technical.

Where as if you wish to print this date in a more human friendly format, you may consider using the following expression.

date([appointment_date],ff)

This can be used in your message as follows:

Dear Customer, 
Your appointment has been confirmed on date([appointment_date],ff).

Outcome

Dear Customer, Your appointment has been confirmed on Nov 6, 2023, 12:00 AM.

Here the result is more natural and easy to understand, also this gives you the flexibility to customize the format of date, just the way like to.

In the above example "ff" short code represents the formatting in which you would like to display the date. instead of "ff", if you use "F", it would return a different date format which would look like 11/6/2023, 12:00:00 AM. You can refer to the following table for different Format Short Codes to achieve a date and time format of your choice.