Supported Relative Date Operations
Date criteria may be filled with a relative Date format. The format follows below codification :
| Code | Value Description |
|---|---|
| NOW | Today (Current Date and Time) |
| DATE | Date passed in parameter |
| BOW | Begin Of Week |
| EOW | End Of Week |
| BOM | Begin Of Month |
| EOM | End Of Month |
| BOQ | Begin Of Quarter |
| EOQ | End Of Quarter |
| BOS | Begin Of Semester |
| EOS | End Of Semester |
| BOY | Begin Of Year |
| EOY | End Of Year |
| +1D | Day |
| +1B | Business Day |
| +1W | Week |
| +1M | Month |
| +1Q | Quarter |
| +1S | Semester |
| +1Y | Year |
Samples Relative Date Operations
This Relative Date engine is used in different part of Minyaa (Timesheet, Report Configuration), and may evaluated against a passed date or the current date. The supported syntaxes can give following samples :
| Sample Operation | Description |
|---|---|
| BOW | 1st day of current week |
| BOW+3D | Thursday of current week |
| BOW(+3D) | 1st day of the week of (Today + 3 Days) |
| NOW | Today |
| NOW+2D | Today + 2 days. Can also defined "+2D" |
| +3B | Today + 3 Business Days (Saturday and Sunday are ignored) |
| +15D+0B | Today + 15 Days and the date is aligned on next Business Day (if resultant date is not s Business Day) |
| +2W-0B | Today + 2 Weeks and the date is aligned on previous Business Day (if resultant date is not s Business Day) |
| EOY(BOQ(EOM(NOW-12W)+3D)-3Q) | This formula executed for March 14' 2013, gives December 31' 2012. You can mix all these functions if is needed ... |