Date parsing in custom formats now available

Calendar dates can be written down in a plethora of ways. Our machine can’t know all of them, so we added the possibility for you to tell the machine what format your date data have.

What is it good for?

This is useful to accept date strings from different locales, incomplete dates or nonstandard date notations. These date strings can then be used in further evaluations in date functions.

How can you use it?

You can use the function date() in Mapping Nodes and Decision Nodes and use it as follows:

date(#param1, "format")
reads a date string from #param1 and interprets it according to format. format is a text that can tell the machine where it finds which date value in #param1.

For US format it would look like this:
date("6/26/2019", "MM/DD/YYYY")
where MM stands for the month, DD for the day and YYYY for the year of the date value.

And for the European format:
date("26.06.2019", "DD.MM.YYYY")

You can find a complete list of format tokens in our references.