Error Messages/40361

Error message examples

 Bad date unit to DateAdd. The third parameter must be "Y", "M", "D", "WD", "h", "m", or "s". 
 Note that "M" is case sensitive with "M" for months and "m" for minutes.

Cause

The third parameter, unit, passed to the DateAdd function was not recognized. The following values can be passed as the third parameter:

• "Y" : Years
• "Q" : Quarters
• "M" : Months
• "D" : Days
• "WD": Weekdays
• "h" : Hours
• "m" : Minutes
• "s" : Seconds

Remedies

Correct the third parameter passed to the DateAdd function.

See Also

• Function calls and parameters
• Function parameter qualifiers
• DateAdd