Home : NDM
Q12890 - INFO: NDM

NDM returns the Number of Days in a Month

SYNTAX:

NDM(MonthOffset)

MonthOffset: The Zero based offset from the Start Date of the report or a date string.  Common values:

0 = Current month
1 = One month after current month
2 = Two months after current month

EXAMPLES:

Start Date of Report is 02/01/2010

Formula  Returns  Explanation
NDM(-1) 31

1 month before start of report is January 2010 which has 31 days.

NDM(0) 28

Current month is Feb 2010 which has 28 days.

NDM(1) 31

1 month after start of report is March 2010 which has 31 days.

NDM("6/25/2010") 30

June 2010 has 30 days.

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 2/23/2010 3:05 PM.
Last Modified on 2/23/2010 4:21 PM.
Last Modified by No Author Name Available!.
Article has been viewed 2967 times.
Rated 6 out of 10 based on 7 votes.
Print Article
Email Article