Date()

Two Dates, Calculate Business Days

Calculates the number of business days between date A and date B. Holidays must be set in advance. Company’s original holidays can be added. For example, this function can be used for calculating the number of business days for the month in advance and planning the work.

Two Datetimes, Calculate Duration

Two Datetimes, Calculate Duration

Calculates the duration between Datetime-A and Datetime-B; like elapsed days (e.g. “1.38 d”), hours (e.g. “33.33 h”), minutes (e.g. “2000.00 min”) and/or time (e.g. “33:20”). A minus sign is given if Datetime-B is earlier than Datetime-A.

Date, Get Weekend Sunday

Date, Get Weekend Sunday

Gets weekend Sundays of any date. If Sunday is specified, that day itself will be returned. If you want to get “Monday of the next week” or “Tuesday of the current week”, you need to convert like #q_date.addDays(1) or #q_date.addDays(-5).

MoneyForward Journal, Create

MoneyForward Journal, Create

Creates the Journal-Slips (TSV or Excel) for MoneyForward Cloud Accounting. It supports not only batch sales invoices but also invoices that are prorated for each month.

Converter: Workflow Datetime to ISO-Datetime-String

Converter: Workflow Datetime to ISO-Datetime-String

Converts Datetime type data (“2021-12-31 20:34” JST) into ISO 8601 datetime string data (“2021-12-31T20:34:00+09:00” or “2021-12-31T11:34:00Z”). As a general rule Datetime type data is regarded as the time of the Workflow Platform time zone.

Converter: ISO-Datetime-String to Workflow Datetime

Converter: ISO-Datetime-String to Workflow Datetime

Converts ISO 8601 datetime string data (“2021-12-31T20:34:56+09:00”, “2021-12-31T11:34:56.789Z”, etc.) to Datetime type data (“2021-12-31 20:34”). The Datetime type data is based on the time zone configured for your Workflow Platform.