Day count current month

Hello, in the query design, what would I use to show the day count for the current month?  

thank you
pdvsaProject financeAsked:
Who is Participating?
 
Dale FyeConnect With a Mentor Commented:
Or

Day(DateSerial(Year(Date()), Month(Date()) + 1, 0))
0
 
ste5anSenior DeveloperCommented:
E.g.  
SELECT Day(DateAdd("m",1+DateDiff("m",#1/1/1900#,Now()),#1/1/1900#)-1) AS Expr1;

Open in new window

0
 
pdvsaProject financeAuthor Commented:
Thank you Dale...:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.