Metaflow - Nidaros Date Time Operations

Nidaros Date Time Operations

Metaflow referentie: Date Time Operations

Get date

Option	Value	Field type
Result	Returns the current date and time	text

Example Get Date

Input	Output
$getDate	19-7-2023 13:30:02

Get UTC date

Option	Value	Field type
Result	Returns the current UTC date and time	text

Example Get UTC Date

Input	Output
$getDate	19-7-2023 11:31:24

Format

Option	Value	Field type
Date	The date to parse to another format	text
Format	The format for the new date	text
New date	The new date in the specified format	text
Error	The error message in case the function has an error	text

Example Format

Input	Format	Output
CurrentDate	yyyy-MM-dd	2023-07-19
CurrentDate	yyyy-MM-dd H	2023-07-19 13
CurrentDate	yyyy-MM-dd HH:mm	2023-07-19 13:33
CurrentDate	yyyy	2023

Modify

Option	Value	Field type
Date	The date to modify	text
Amount	The amount to add from the date (add an '-'before the amount to decrease it from the date)	text
Unit type	The type of time you want to add to the date	text
Type	The type of modifying the date	text
New date	The new date that is modified	text
Error	The error message in case the function has an error	text

Example Modify

Input	Amount	Unit Type	Type	Output
CurrentDate	5	Hours	Add	19-7-2023 05:00:00
CurrentDate	2	Days	Substract	17-7-2023 00:00:00
CurrentDate	1	Months	Add	19-7-2024 00:00:00

Parse

Option	Value	Field type
Input	The text to parse to a date	text
Culture	(optional) The culture to use to parse the date. Leave empty to use the systems culture	text
Output	The parsed date	text
Error	The error message in case the function has an error	text

Example Parse

Input	Culture	Output
19-7-2023 13:38:51	nl_NL	19-7-2023 13:38:51
19/7/2023 13:38:51	nl_NL	19-7-2023 13:38:51
2023/07/19 13:38:51	en_US	19-7-2023 13:38:51
2023-07-19 13:38:51	en_US	19-7-2023 13:38:51