|
|
|
|
|
Expression |
Result |
"12-jan-2007"+ 1 MONTH |
February 12, 2007, 0:00 |
ADATE ("BOM") + 12 DAYS |
12 days after first of this month |
ADATE ("MONDAY") + 2 WEEKS |
2 weeks from next Monday |
ADATE ("MONDAY_THIS_WEEK") - 2 WEEKS |
2 weeks before Monday |
ADATE ("NOW") + 12 HOURS |
12 hours from the current time |
ADATE ("END_OF_YEAR") - 12 DAYS + 2 HOURS |
2:00 AM, 12 days before the end of the year |
ADATE ("bom") + 2 MONTH - 1 DAY |
Last day of next month |
FORMAT="ZZ9" (ADATE "eoy" - "boy")/1 DAY + 1 |
Number of days in the current year |