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

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 is shown in Figure 1.

Figure 1 Example specified now
Wagby provides NOW function separately from now notation.(Or there is a TODAY function.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.)

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

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".