Date Time Functions date-time
Date and time functions are used to perform date and time operations on values within Journey Optimizer.
Age age
The age
function is used to retrieve the age from a given date.
Syntax
{%= age(datetime) %}
Current time in milliseconds current-time
The currentTimeInMillis
function is used to retrieve current time in epoch milliseconds.
Syntax
{%= currentTimeInMillis() %}
Date difference date-diff
The dateDiff
function is used to retrieve the difference between two dates in number of days.
Syntax
{%= dateDiff(datetime,datetime) %}
Day of week day-week
The dayOfWeek
function is used to retrieve the day of week.
Syntax
{%= dayOfWeek(datetime) %}
Day of year day-year
The dayOfYear
function is used to retrieve the day of year.
Syntax
{%= dayOfYear(datetime) %}
Format date format-date
The formatDate
function is used to format a date time value. The format should be a valid Java DateTimeFormat pattern.
Syntax
{%= formatDate(datetime, format) %}
Where the first string is the date attribute and the second value is how you would like the date to be converted and displayed.
Example
The following operation will return the date in the following format: MM/DD/YY.
{%= formatDate(profile.timeSeriesEvents._mobile.hotelBookingDetails.bookingDate, "MM/dd/YY") %}
Format date with locale support format-date-locale
The formatDate
function is used to format a date time value into its corresponding language sensitive representation, i.e in a desired locale. The format should be a valid Java DateTimeFormat pattern.
Syntax
{%= formatDate(datetime, format, locale) %}
Where the first string is the date attribute, second value is how you would like the date to be converted and displayed and the third value represents the locale in string format.
Example
The following operation will return the date in the following format: MM/DD/YY and locale FRANCE.
{%= formatDate(profile.timeSeriesEvents._mobile.hotelBookingDetails.bookingDate, "MM/DD/YY", "fr_FR") %}
Set days set-days
The setDays
function is used to set the day of the month for the given date-time.
Syntax
{%= setDays(datetime, day) %}
Set hours set-hours
The setHours
function is used to set the hour of the date-time.
Syntax
{%= setHours(datetime, hour) %}
To UTC to-utc
The toUTC
function is used to convert a datetime to UTC.
Syntax
{%= toUTC(datetime) %}
Week of year UTC week-of-year
The weekOfYear
function is used to retrieve the week of the year.
Syntax
{%= weekOfYear(datetime) %}