DateFormula Property

Sets a date formula used to verify that the date the user enters is correct.

  • Fields

  • Forms

  • Pages

  • Text boxes

The following table shows the syntax 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 text box and field settings are checked during validation.

NoteNote

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

Community Additions

ADD
Show: