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. |