Date()

Two Datetimes, Calculate Duration

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

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.