By using date formulas in Microsoft Dynamics NAV, you can tell the program how to calculate dates. You can enter date formulas in various date calculation fields and in recurring frequency fields in recurring journals.
Here are some examples of how date formulas can be used:
The date formula in the recurring frequency field in recurring journals determines how often the entry on the journal line will be posted.
The date formula in the Grace Period field for a specified reminder level determines the period of time that must pass from the due date (or from the date of the previous reminder) before a reminder will be created.
The date formula in the Due Date Calculation field determines how the program calculates the due date on the reminder.
The date calculation formula can contain a maximum of 20 characters, both numbers and letters. You can use the following letters, which are abbreviations for time specifications:
C |
Current |
D |
Day(s) |
W |
Week(s) |
M |
Month(s) |
Q |
Quarter(s) |
Y |
Year(s) |
You can construct a date formula in three ways:
Current plus a time unit. For example:
CW |
Current week |
CM |
Current month |
A number and a time unit. A number cannot be larger than 9999. For example:
10D |
10 days from today |
2W |
2 weeks from today |
A time unit and a number. For example:
D10 |
The next 10th day of a month |
WD4 |
The next 4th day of a week (Thursday) |
You can combine these three forms as needed. For example:
CM+10D |
Current month + 10 days |
You can use a minus sign to indicate a date in the past. For example:
-1Y |
1 year ago from today |