Find no of Days in Previous month

[tasawer]

Hi,

I need help to create an sql command to find no of days in the current month of calculation and no of days in the month previous to it.

This code works for the current month, but only because mgmtstart is always 1st of the month.

DaysinMonth: DateDiff("d",[mgmtDateStart],DateSerial(Year([mgmtdatestart]),Month([mgmtdatestart])+1,1))

your help is greatly appreciated.

[yarbrough40]

I believe Access has a DateAdd() function. I think this is what you want.

[missinglinq]

DaysInPreviousM onth:Day(DateSe rial(Year(Date) , Month(Date), 0))

Linq ;0)>

[NeoPa]

And, by extension :

DaysInMonth: Day(DateSerial(Year(Date), Month(Date) + 1, 0))