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.

See Also

Reference

DateFormula Data Type