Date, Calc after N Business Days
Calculates N business days after the specified date. If N is negative, returns N business days ago. It is necessary to set a holiday in advance. It is also possible to add company-original holidays.
Date()
Date, Determine Whether Business Day
Determines whether the date value is Business Day or not. If holiday, returns the name of holiday. If Sat or Sun, returns the day name. Otherwise, returns an empty string. You can also set special holidays set by your company.
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).
Date, Get Day of Week String
Gets the string for the day of the week. The notation of the day is set in the config such as “Sun,Mon,Tue,Wed,Thu,Fri,Sat” or “Closed,Open,Open,Open,Open,Open,Closed”. The beginning is Sunday.
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: Datetimes in different time zones
Converts the datetime in time zone A to the datetime in time zone B. Any time zone can be set for either datetimes. If nothing is set the Workflow Platform time zone will be applied.
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
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.
Converter: Timestamp-Number to Datetime
Converts a timestamp number (UNIX time) to datetime data. That is, the number of seconds elapsed since UTC 1970-01-01 00:00:00 is assigned to the datetime type data according to the workflow platform time zone. (10-digit integer after 2002)
OpenWeather: Weather History, Get by Time
Gets weather history for the specific time from OpenWeather (corrected to zero minutes) with the specified latitude and longitude. Temperature, humidity and wind speed can be obtained as well as snow volume and wind gust.
OpenWeather: Weather Forecast, Get by Time
Gets weather forecast for the specific time (corrected to zero minutes) from OpenWeather with specifying latitude and longitude of the world. Not only temperature, humidity and wind speed, but also visibility and sensible temperature can be obtained.
OpenWeather: Weather Forecast, Get by Date
Gets weather forecast for the specific date from OpenWeather with specifying latitude and longitude of the world. Not only temperature, humidity and wind speed, but also sunset time and dew point temperature can be obtained.
Two Datetimes, Calculate Duration
Calculates the duration between datetime A and B to output as numerical value (days), numerical value (hours), numerical value (minutes), or string value (h:mm). If B is the past time, a minus sign will be added. Date type also available.
MoneyForward Journal, Create
Creates the Journal-Slips (TSV or Excel) for MoneyForward Cloud Accounting. It supports not only invoices that are booked as single sales record, but also invoices that are booked as monthly sales records.
Journal-TSV Create
Creates the Journal-Slip TSV. The transfer slip TSV of the sales is generated based on the Invoice data. To generate a file that can be imported into the accounting system, place a converter such as “TSV to Excel-CSV FILE” in the downstream process.
Journal Slip TSV from Invoice Data
Generate transfer slip TSV (tab-separated-values) with sales amount, sales date, due date. It supports cases where add a sales collectively or divided into several months or mixture of those. In order to generate a file for the accounting system, you need to place a converter such as “TSV to Excel-CSV FILE”.
TSV Filtering by Date
Filter a row in a tab-delimited text (TSV) stored in a String type Data Items by date range and save. dateString should be in a format recognized by the Date.parse() method. Date-only strings (e.g. “1970-01-01”) are treated as UTC, not local.