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 %}
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
Format | Description | Example returned values |
---|---|---|
Day | — | — |
d | Day of the month, 2 digits with leading zeros | 01 to 31 |
D | A textual representation of a day, three letters | Mon through Sun |
j | Day of the month without leading zeros | 1 to 31 |
l (lowercase ‘L’) | A full textual representation of the day of the week | Sunday through Saturday |
N | ISO-8601 numeric representation of the day of the week (added in PHP 5.1.0) |
1 (for Monday) through 7 (for Sunday) |
S | English ordinal suffix for the day of the month, 2 characters | st, nd, rd or th. Works well with j |
w | Numeric representation of the day of the week | 0 (for Sunday) through 6 (for Saturday) |
z | The day of the year (starting from 0) | 0 through 365 |
Week | — | — |
W | ISO-8601 week number of year, weeks starting on Monday | Example: 42 (the 42nd week in the year) |
Month | — | — |
F | A full textual representation of a month, such as January or March | January through December |
m | Numeric representation of a month, with leading zeros | 01 through 12 |
M | A short textual representation of a month, three letters | Jan through Dec |
n | Numeric representation of a month, without leading zeros | 1 through 12 |
t | Number of days in the given month | 28 through 31 |
Year | — | — |
L | Whether it’s a leap year | 1 if it is a leap year, 0 otherwise. |
o | ISO-8601 week-numbering year. This has the same value as Y, except that if the ISO week number (W) belongs to the previous or next year, that year is used instead. |
Examples: 1999 or 2003 |
Y | A full numeric representation of a year, 4 digits | Examples: 1999 or 2003 |
y | A two digit representation of a year | Examples: 99 or 03 |
Time | — | — |
a | Lowercase Ante meridiem and Post meridiem | am or pm |
A | Uppercase Ante meridiem and Post meridiem | AM or PM |
B | Swatch Internet time | 000 through 999 |
g | 12-hour format of an hour without leading zeros | 1 through 12 |
G | 24-hour format of an hour without leading zeros | 0 through 23 |
h | 12-hour format of an hour with leading zeros | 01 through 12 |
H | 24-hour format of an hour with leading zeros | 00 through 23 |
i | Minutes with leading zeros | 00 to 59 |
s | Seconds, with leading zeros | 00 through 59 |
Timezone | — | — |
e | Timezone identifier (added in PHP 5.1.0) | Examples: UTC, GMT, Atlantic/Azores |
I (capital i) | Whether or not the date is in daylight saving time | 1 if Daylight Saving Time, 0 otherwise. |
O | Difference to Greenwich time (GMT) in hours | Example: +0200 |
P | Difference to Greenwich time (GMT) with colon between hours and minutes | Example: +02:00 |
T | Timezone abbreviation | Examples: EST, MDT … |
Z | Timezone offset in seconds. The offset for timezones west of UTC is always negative, and for those east of UTC is always positive. |
-43200 through 50400 |
To stay updated with the latest features, news and how-to articles and videos, please join our group on Facebook, Flexie CRM Academy.