Block Category | Date/Time |
Block Name | Date Format |
Description | Returns a String of formatting characters that specifies a date format. |
Script | “format” |
Inputs | format – A string that represents the format of the datetime value: – mm/dd/yy – mm/dd/yyyy – mmddyy – mmddyyyy – dd/mm/yy – dd/mm/yyyy – ddmmyy – ddmmyyyy – yyyymmdd – yyyyddmm – yyyy-mm-dd – yy-mm-dd – yyyy-dd-mm – yy-dd-mm |
Returned Value | String representing date format. |
Examples | This example returns “mm/dd/yy” date format. Script: “mm/dd/yy” |
Block Category | Date/Time |
Block Name | Date/Time Format |
Description | Returns a string of formatting characters that specifies a datetime format. |
Script | “format” |
Inputs | You can select from: • yyyy-mm-dd hh:nn:ss • yyyy-dd-mm hh:nn:ss • yyyy-mm-ddThh:nn:ss |
Returned Value | String representing datetime format. |
Examples | The following example returns “yyyy-mm-dd hh:nn:ss” datetime format: Script: “yyyy-mm-dd hh:nn:ss” |
Block Category | Date/Time |
Block Name | Time Format |
Description | Returns a string of formatting characters that specifies a time format. |
Script | “format” |
Inputs | You can select from: • hh:nn:ss • hh:nn:ss AM/PM • hh:nn • hh:nn AM/PM • hhnnss • hhnn |
Returned Value | String representing a time format. |
Example | The following example returns “hh:nn:ss” time format. Script: “hh:nn:ss” |
Block Category | Date/Time |
Block Name | String to Date/Time |
Description | Converts a String representation of a datetime, date or time into a datetime value. |
Script | ToDatetime(“datetime”,“format”) |
Inputs | datetime – A string that represents a datetime value. format – A string that represents the format of the datetime value: • mm/dd/yy • mm/dd/yyyy • mmddyy • mmddyyyy • dd/mm/yy • dd/mm/yyyy • ddmmyy • ddmmyyyy • yyyymmdd • yyyyddmm • yyyy-mm-dd • yy-mm-dd • yyyy-dd-mm • yy-dd-mm |
Returned Value | A datetime value. |
Examples | The following example converts a string datetime (“05/12/23”) into a real datetime value in the specified date format (“mm/dd/yy”). Script: ToDatetime("05/12/23","mm/dd/yy") |
Block Category | Date/Time |
Block Name | Date/Time to String |
Description | Converts a datetime, date or time into a string value. |
Script | FromDatetime(datetime,“format”) |
Inputs | datetime – A datetime value. format – A string that represents the format of the datetime value: • mm/dd/yy • mm/dd/yyyy • mmddyy • mmddyyyy • dd/mm/yy • dd/mm/yyyy • ddmmyy • ddmmyyyy • yyyymmdd • yyyyddmm • yyyy-mm-dd • yy-mm-dd • yyyy-dd-mm • yy-dd-mm |
Returned Value | A string that represents a datetime value. |
Example | The following example formats the datetime from source field @due_date into a string datetime of the specified format (“mm/dd/yy”). Script: FromDatetime(@due_date,"mm/dd/yy") |
Block Category | Date/Time |
Block Name | Convert Formats |
Description | Converts a date from one string format to another. |
Script | DateConvert(fromFormat,toFormat,value) |
Inputs | fromFormat – Original format of the source date string. This should be same as the format of the value parameter. toFormat – Desired format of the output date string. value – The date to be converted. |
Returned Value | A date string in the specified date format. |
Examples | The following example converts a date from source field “due_date” from “mm/dd/yy” to “yyyymmdd” format: Script: DateConvert("mm/dd/yy","yyyy/mm/dd",@due_date) |
Block Category | Date/Time |
Block Name | Now |
Description | Returns the current system date and time as per your local time zone settings. |
Script | Now() |
Inputs | None |
Returned Value | The current system date and time. |
Remarks | Now returns a date containing a date and time that are stored internally as a double-precision number. This number represents a date and time from January 1, 100 through December 31, 9999, where January 1, 1900 is 2. Numbers to the left of the decimal point represent the date; numbers to the right represent the time. Note: Since date and time are stored internally as a double-precision number, you may have to adjust the output field size on the mapping page. |
Example | This example returns the current system datetime of your local machine after converting it from its current format, “yyyy-mm-dd hh:nn:ss” into “yyy-mm-ddThh:nn:ss”: Script: DateConvert("yyyy-mm-dd hh:nn:ss","yyyy-mm-ddThh:nn:ss",Now()) |
Block Category | Date/Time |
Block Name | Time |
Description | Returns the current system time as per your local time zone settings. |
Script | Time() |
Inputs | None |
Returned Value | An eight-character string in the form of hh:mm:ss, where hh is the hour (00 - 23), mm is the minute (00 - 59), and ss is the second (00 - 59). A 24-hour clock is used; therefore, 6:00 P.M. displays as 18:00:00. |
Example | This example returns the current system time of your local machine: Script: Time() |
Block Category | Date/Time |
Block Name | Date |
Description | Returns the current system date as per your local time zone settings. |
Script | Date() |
Inputs | None |
Returned Value | The Date function returns the date as a formatted string, formatted based on the current locale settings for the machine. |
Example | This example returns the current system date of your local machine after converting it from its current format, “dd/mm/yy” into “yyy-dd-mm”: Script: DateConvert("dd/mm/yy","yyyy-dd-mm",Date()) |