Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

DateFormula Property

Microsoft Dynamics NAV 2013

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

  • Table Fields

  • Page Fields

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.

Dd301476.note(en-us,NAV.70).gifNote
We do not recommend that you use this property, but use the DateFormula Data Type instead.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.