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 Dynamics NAV, weeks begin on Monday and end on Sunday.

For fields, this property only applies to text fields. In earlier versions of Dynamics NAV, the property also applied to code fields, but this has been deprecated.

Note

We recommend that you do not use this property. Use the DateFormula Data Type instead.

See Also

DateFormula Data Type