Customize

Get Specific Date

Summary

Gets a specific date so that it can be referenced by other actions.

How to use

If you want to include the retrieved date in the field, select that field in the “Destination field (optional)” parameter.

If you want to use the acquired date in another field instead of putting it in the field immediately, use the formula.

When you perform an action set to Get a specific date, the date is stored internally as a result of the action.

You can use a formula to get the saved date, for example, = $1.

The saved date is in a format that can be set directly into the kintone date field.

Example) An example of using the acquired date as another action ("Add record")

  1. Set up “Get a specific date”. The action number is number one.
  2. Set a value in a field, enter = $1 in Value. (If the action number for “Get a specific date” is number 2, say “= $2”)

Parameters to set

Set the Date Type.

Date Type

Select the date you want to retrieve, such as Today or At the beginning of this month.

Other methods

You can also use a function in a formula without using an action.

Set a value in a field in the “Value” parameter, for example,

=getDate("First of this month")

You can specify a function, such as.

The “beginning of this month” part of the above example can be one of the following:

  • today
  • yesterday
  • tommorow
  • first_day_of_this_month
  • last_day_of_this_month
  • first_day_of_last_month
  • last_day_of_last_month
  • first_day_of_next_month
  • last_day_of_next_month
  • first_day_of_this_year
  • last_day_of_this_year
  • first_day_of_last_year
  • last_day_of_last_year
  • first_day_of_next_year
  • last_day_of_next_year
  • first_day_of_this_fiscal
  • last_day_of_this_fiscal
  • first_day_of_last_fiscal
  • last_day_of_last_fiscal
  • first_day_of_next_fiscal
  • last_day_of_next_fiscal

Set destination field (optional)

Specify this when setting the acquired date in another field. If you do not set it in the direct field and you want to use the result in another action, you can omit it.

Limitations

  • The standard today’s date is based on the time zone (time difference) set for the “Time Zone” in the profile settings of the user logging into kintone. It cannot be fixed to a specific time zone (e.g. Japanese time).

  • In this “thing to do”, the range of “fiscal year” is fixed from April to March. It is not possible to get the start date of the year in a different year range.