Support > Repository > Initial value > Special notation that can be specified by date, time, date and time type now
ja | en

You can specify the current date and time by setting "now" to the value.

By writing "now" as the initial value, you can specify the current date and time.

Figure 1 Setting of notation
When using "now", please leave the type field blank.

"Now + 1" expresses the next day."Now - 1" expresses the previous day.In addition, you can make the following specifications.

type Description
now That day
now+1 next day
now-1 The previous day
now+1M Next month
now-1M last month
now:firstday It represents the first day of the month.Example) If today's date is 2016-02-14, it will be "2016-02-01".
now:lastday It represents the last day of the month.Example) If today is 2016-02-14, it will be "2016-02-28".
now:everyXX It represents the next XX day.Example) If today is 2016-02-14 and XX is 25, it will be "2016-02-25".If today is 2016-02-14 and XX is 10, it will be "2016-03-10".
now+1M:firstday It represents the first day of the next month.If today is 2016-02-14, it will be "2016-03-01".

An example of execution is shown in Fig.

Figure 1 Example executed now
Wagby is apart from now notationNOW functionOrTODAY functionAlso available.In this case, the NOW function is a date-time type, and the TODAY function is specified as a date type.(Different combination will result in an error.)
* Operations like now + 1 and now-1 (provided by Wagby)Date Time FunctionIt can also be realized with a combination of.

In the case of using the now notation, the time of the actual operation timing is set.
To set the time portion to zero,CLEARHMS functionPlease apply.

CLEARHMS(now:firstday)

The handling of now differs according to the type by "date" "time" "date time".

Type What pointed by now An example
date Today's date
2014/02/14 etc.
"Now + 1" is the next day (one day after today's date).
"Now + 1 M" is one month after today's date.
time Current time
11: 46: 13 etc.
'Now + 1' is one second after the current time.
"Now + 3600" is one hour after the present time (after 3600 seconds).
Date and time Current date and time
2014/02/14 11: 46: 13 etc.
"Now + 1" refers to the current time after one day.
In the example on the left it is "2014/02/15 11: 46: 13".