Date() – Questetra Support

2024-07-05

Converter (Date to Japanese calendar text)

Date()

This item converts a Date / Datetime type data item to Japanese calendar text and stores it in a String…

2023-01-12

Two Dates, Calculate Business Days

Date()

Calculates the number of business days between date A and date B. Holidays must be set in advance. Company’s original…

2022-12-29

Two Datetimes, Calculate Duration

Date() Easy-Config Addon

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…

2022-12-29

Converter: Date-or-Datetime-String to Workflow Datetime

Date() Easy-Config Addon

Converts strings such as “2022-12-31” or “2022-12-31 00:00” to Datetime (or Date) data. Also supports strings like “2022/12/31” and “19700101”.…

2022-11-18

TSV String, Convert date data to yyyy-MM format

Date() TSV CSV

Converts the date data in the specified column to yyyy-MM or yyyy format and appends the value to the end…

2022-10-12

Two Dates, Calculate Business Days

Date()

Calculates Business Day Count between datetime A and B to output as numerical value (days).

2021-10-05

#Date: Calc after N Business Days

Approval Flows Date() Expense Claim Routine Report

Calculates N business days after the specified date. If N is negative, returns N business days ago. It is necessary…

2021-10-05

#Date: Determine Whether Business Day

Attendance Mgmt. Date() Routine Report

Determines whether the date value is Business Day or not. If holiday, returns the name of holiday. If Sat or…

2021-10-05

#Date: Get Weekend Sunday

Attendance Mgmt. Date() Easy-Config Addon

Gets weekend Sundays of any date. If Sunday is specified, that day itself will be returned. If you want to…

2021-10-05

#Date: Get Day of Week String

Attendance Mgmt. Date() Easy-Config Addon Inquiry Response

Gets the string for the day of the week. The notation of the day is set in the config such…

2021-08-04

MoneyForward Journal, Create

Date() TSV CSV

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

2021-03-03

Converter: Datetimes in different time zones

Date()

Converts the datetime in time zone A to the datetime in time zone B. Any time zone can be set…

2021-03-03

Converter: Workflow Datetime to ISO-Datetime-String

Date()

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…

2021-03-03

Converter: ISO-Datetime-String to Workflow Datetime

Date()

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…