Set Variables for Dates in Templates
Set Variables for Dates in Templates
Instead of using fixed dates in templates, variables can be used:
| day part of date |
- D - today
- P - initial day
- Z - last day
|
| month part of month |
- M - current month
- P - first month of the current quarter
- Z - last month of the current quarter
|
| year part of date |
L - current year |
| work day |
W - work day |
Work day templates should be started and finished with # symbol. Supported templates (for example):
#dd+W.mm.yyyy# - today if it's a work day or next work day (d+W is equivalent to d+0W)
#dd-W/mm/yyyy# - today if it's a work day or prev work day (d-W is equivalent to d-0W)
#d+1W/mm/yyyy# - next work day after today
#dd-1W.m.yyyy# - last work day before today
#dd+6W.mm.yy# - sixtth work day after today
#yyyy-mm-dd+5+7W# - today plus five day and then get sevens work day
#dd-5W+3.mm.yyyy# - today minus five work days and then plus three days
#ddp+10W.mm.yyyy# - tenth work day of current month
#ddz-10W.mm.yyyy# - tenth work day before end of current month
#ddp+14+2W.mm.yyyy# - sencond work day after two first weeks of month
If you need to specify 15 day of month or next work day (if 15 day is a holiday) then you can use the following template #ddp+14+w.mm.yyyy#
Add or deduct values using this variables.
This is an easy-to-use way for defining entire forms (e.g. quarterly chocolate sales report).
See also: using variables for dates in templates.