ja | en

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