Number of days in DateField

[gudguy]

Hello,

I just need your expertise on date formula in Access.

I'm running Access Query, in which I'm adding a new field that outputs the number of days in a month.


Ex.: MY fields in Access Query is:

StartDate Users Expr1 (new field Im adding)
7/7/04 20 Number of days in StartDate field


In Expr1 field, I want to insert a formula to output number of days in 'startdate' field.


Thank you for your help in advance

 

[amorous]

try this link:

http://www.extremeexperts.com/sql/Tips/DateTrick.aspx

-VJ

 

[MichaelRed]

SELECT tblStrtDt.StartDate, Format(DateSerial(Year([StartDate]),Month([StartDate])+1,0),"dd") AS NumDays
FROM tblStrtDt;




MichaelRed
mlred@verizon.net

 

[gudguy]

Thank you for your reply. I looked at the link. I'm not sure if this script works in Access Query in the Expr field.

Wondering if there is a simple return of number to month. There are many 'builtin functions with onversions in date/time for complex date calculations, but couldn't find a simple formula to get number of days in a month.

Anyway, can I copy and paste this script in Microsoft Access Query field?

 

[PHV]

Have you tried this ?
Expr1: Format(DateSerial(Year([StartDate]),Month([StartDate])+1,0),"dd")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244