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