Job Runner

Get Specific Date

Overview

Get a specific date to reference from other actions.

Usage

When you execute an Action set to run “Get Specific Date,” the calculation’s result is stored internally.

You can get the calculated date using a formula, for example, “=$1.”

The saved date is formatted to be exported to a Date field in Kintone without modifications.

Example: Re-using the calculated date in an Action that runs the Do “Add New Record.”

  1. Set an Action that runs the Do “Get Specific Date.” Assume that the Action Number is “1.”
  2. Next, open the “Mapping” menu of “Add New Record”, find the “Date” field that should receive the calculated date and enter the formula “=$1.” (If the Action Number for “Get Specific Date” is #2, change the formula to “=$2”.)

All specifications, such as This Month or Next Month, are based on the date the action is executed. The date is interpreted according to the time zone setting in Set Time Zone. If you haven’t “Set Time Zone,” it will be JST.

If you want to base it on any date, you can use Get Specific Date by Providing Date.

Parameters

Set Date Type.

Date Type

Select the date you want to retrieve, such as today or early this month.

You can choose from the following:

  • Today
  • Yesterday
  • Tomorrow
  • Earlier this month
  • End of month
  • Early last month
  • Last day of last month
  • Early next month.
  • Last day of next month
  • Early this year (January 1)
  • End of this year (December 31)
  • Early last year (January 1)
  • End of last year (December 31)
  • Early next year (January 1)
  • End of next year (December 31)
  • First day of this fiscal year (April 1)
  • Last day of the current fiscal year (March 31)
  • First day of last year (April 1)
  • Last day of last fiscal year (March 31)
  • First day of next school year (April 1)
  • Last day of next school year (March 31)

Alternative Solutions

Another option is to use the getdate function in an expression to get it without using any actions.

For example, in the value parameter of Set Field, write as follows:

=getDate ("early this month")

Restrictions

  • The Fiscal Year range is fixed from April to March. It is impossible to obtain the fiscal year’s start date, etc. in a different fiscal range.