Customize

Get Specific Date by Providing Date

Summary

Get a specific date based on a provided date to reference from other actions.

How to use

To set the obtained date to another field, enter the target field into the parameter “Target Field (Optional)”.

Use formulas when using the obtained date for other actions without setting it immediately.

When you execute an action to run “Get Specific Date by Providing Date”, the obtained date is stored internally.

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

The saved date is formatted so that it can be set directly in the Date field of Kintone.

Example: Use the obtained date in another action, “Add New Record.”

  1. Set “Get Specific Date by Providing Date.” Supposing the action number is 1.
  2. In the “Mapping” section of “Add New Record”, enter “$1” for the date field you want to set. (If the action number of “Get Specific Date by Providing Date” is 2, change the formula to “=$2”.)

Parameters

Set Base Date, Date Format, and Target Field (Optional).

Base Date

Specify the reference date.

To access the value of a Date field or a Date and time field, use the field code:

Example: =Date_2

insert an equals sign “=” before the field code, as in the example.

Date Format

Select the desired date, such as “Previous day”, “Next day”, and “First day of the month.”

You can choose from the followings:

  • Previous day
  • Next day
  • First day of the month
  • Last day of the month
  • First day of last month
  • Last day of last month
  • First day of next month
  • Last day of next month
  • First day of the year (Jan. 1)
  • Last day of the year (Dec. 31)
  • First day of last year (Jan. 1)
  • Last day of last year (Dec. 31)
  • First day of next year (Jan. 1)
  • Last day of next year (Dec. 31)
  • First day of fiscal (Apr. 1)
  • First day of fiscal (Mar. 31)
  • First day of last fiscal (Apr. 1)
  • End day of last fiscal (Mar. 31)
  • First day of next fiscal (Apr. 1)
  • Last day of next fiscal (Mar. 31)

Target Field (Optional)

Use this parameter to set the obtained date to another field. You can omit this parameter if you do not set the results directly in the field but use it in another action.

If you select a field inside a table, all rows of that table will be processed. For exceptions: See (*1)

*1: Only the affected rows will be processed if you set a condition that applies only to some table rows (such as “When Fields Value Changed”).

This parameter accepts the following field types:

  • Text
  • Text area
  • Rich text
  • Date
  • Date and time

Compatibility with krewSheet

This action is designed to work seamlessly with krewSheet.

However, the following restrictions apply to the parameter “Target Field (Optional)":

  • This parameter cannot be set to a field obtained by a Lookup field.
  • The following field types can be set when a record is saved (e.g. when you select the Condition “Before Record Saved Excluding Deleted"): If you want to gain more technical knowledge, refer to the krewSheet documentation .
    • Fields not included in the krewSheet view’s columns
    • Fields set to read-only in krewSheet
    • Rich text field

Restrictions

  • The reference date for today is based on the time zone set in the profile settings of the user logged into Kintone. You cannot fix it to a specific time zone (for example, JST).

  • The range of the “fiscal year” is fixed from April to March. You cannot obtain the fiscal start date in different fiscal year ranges.