Get a Day of the Week from Date

Overview

Get a day of the week from the specific date to reference from other actions.

When you execute an Action set to run “Get a Day of the Week from Date,” the calculation’s result is stored internally.

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

The saved day of the week does not contain a date, so it cannot be set in the Kintone Date field. However, it can be set to a Text field.

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

First, set an Action that runs the Do “Get a Date on the Day of the Week.” Assume that the Action Number is “1.”
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 of “Calculate Date” is “2”, change the formula to “=$2”.)

Set Date, Language, and Format.

Enter the date you want to calculate the day of the week.

If you want to access the value of a “Date” field or a “Date and time” field, input the field code as shown in the example below:

=Date_2

Remember to use an equals sign (=) before the field code to access the value of that field.

If you want to calculate the day of the week for the current date:

=today()

Values that cannot be interpreted as empty values or dates cause an error at runtime.

Specify which language to use for the day of the week.

Choose whether to display in a long or short format.

The long form is “Wednesday,” and the short form is “Wed.”

Languages other than Japanese and English (such as Chinese) are not supported.