Method

date – Format a date and returns a format that you are accustomed or want to use.

Description

Minimum number of arguments for this method is one, the date. You can enter a date Field Alias if you want to manipulate date from a field or a function or a string.

You can also add the format you want the date to show and convert date between time zones. You can use many options that best fit how you want the date to look like.

Structure of the method:

date('date string', 'format', 'To Timezone', 'From Timezone')

You can enter field values that are datetime or functions. You can compare between dates and create logic in your templates. The date printed will be in UTC if you don’t use To and From timezone arguments. If you want to convert to your time zone use the To and From timezones.

// Will convert today's UTC date to Europe/San_Marino timezone.
date('now','F j, Y, g:i A','Europe/San_Marino','UTC')

Parameters

date — String date that you may get from Field Alias like lead.date_added or from functions like now

format — The desired date format. There are many options you can use as this supports all the php date time formats.

To Timezone — Timezone you want to convert to like Europe/San_Marino

From Timezone — If this parameter is not set, it will convert from the UTC by default

Examples

Suppose you have a service with a trial period and you wish to check in an email template if their trial has ended you notify them with an email.

Hello {{first_name}},

{% if date(lead.date_added) < date('-1 month') %}

     // Print something or a snippet

{% else %}

     // Print something else or another snippet

{% endif %}

Calculate difference between two dates:

{{ round((date("2020-01-01 19:17:54", "U") / 60 / 60 / 24) - (date("2019-12-15 18:34:00", "U") / 60 / 60 / 24)) }}

date("2020-01-01 19:17:54", "U") - Caculate seconds
/ 60 / 60 / 24 - divides seconds to calculate the number of days

Or you can divide by 86400 which is the number of seconds of a day. 

// Output: 17 days

Adding minutes to a lead’s added date: Date Added: Apr 4, 15:23

{{date(date_added  ~ '+30 minutes', 'F j, Y, g:i A', 'Europe/London', 'UTC')}}

// Output: April 4, 2018, 15:53 PM 
// Adds 30 minutes to the date_added datetime. 

Suppose you have a lead added on the following date: Date Added: Apr 4, 15:23

{{date(date_added, 'F j, Y, g:i A', 'Europe/London', 'UTC')}}

// Output: April 4, 2018, 2:23 PM

{{date('now', 'Y-m-d H:i:s','Europe/London')}}

// Output: 2018-04-04 14:23:42

To stay updated with the latest features, news and how-to articles and videos, please join our group on Facebook, Flexie CRM Academy and subscribe to our YouTube channel Flexie CRM.