DateFormula Property
Sets a date formula used to verify that the date the user enters is correct.
Applies To
Table Fields
Page Fields
Remarks
The following table shows the syntax that is used to create the date formula.
| Syntax | Description |
|---|---|
30D |
30 days |
2W |
2 weeks |
CM+10D |
Current month plus 10 days |
CM+1M |
Current month plus one month |
CQ+1M+20D |
Current quarter plus one month plus 20 days |
CW+1W |
Current week plus one week |
D15 |
On the 15th of each month |
In Microsoft Dynamics NAV, weeks begin on Monday and end on Sunday.
For fields, this property only applies to text and code fields.
The field settings are checked during validation.
Note
We do not recommend that you use this property, but use the DateFormula Data Type instead.