Days in Month

[VBXL]

Hi

Is the a formula to work out how many days are there in a month.

 

[tlbroadbent]

SELECT DAY(DATEADD(d, -DAY(GETDATE()),DATEADD(m,1,GETDATE())))

These links contain scripts that find the last day of the month.

http://www.planet-source-code.com/xq/ASP/txtCodeId.312/lngWid.5/qx/vb/scripts/ShowCode.htm

http://vyaskn.tripod.com/code.htm#lastday

http://www.devx.com/free/tips/tipview.asp?content_id=3182

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[mukund]

Hi Xplain,
See the following query.

select DateDiff(d,getdate(), Dateadd(m, 1, getdate())) as NoOFDays

I have used system date function getdate() as an example. You can form the date when a month is supplied.

Suppose a month & year is passed
you can form the date by concatenating
month/day/year
month & year can be passed & day can be kept constant as 1.

Hope this helps.

Mukund.