Is there a function I can use to get the number of days in a month?
Let's say a user enters a date 01/23/2003, how can I tell that the month has 31 days without going through all the coding and validation of what month it is?

Thanks,
Judy

Judy,

I don't know if there is an inbuilt function for this but you can use something like

function daysInMonth(dateIn)
    dim startDate, endDate
    startDate = year(dateIn) & "/" & month(dateIn) & "/1"
    endDate = year(dateIn) & "/" & month(dateIn) + 1 & "/1"
    daysInMonth = dateDiff("d",startDate,endDate)
end function


Rod

======================================
They say, best men are moulded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

This is better way of doing as the earlier function

function daysInMonth(dateIn)
    dim startDate, endDate
    startDate = year(dateIn) & "/" & month(dateIn) & "/1"
    endDate = year(dateIn) & "/" & month(dateIn) + 1 & "/1"
    daysInMonth = dateDiff("d",startDate,endDate)
end function

would fail if the month for which you want the number of days is December

So here I am using the inbuilt dateadd function that would generate the next month.

function daysInMonth(dateIn)
    dim startDate, endDate
    startDate = year(dateIn) & "/" & month(dateIn) & "/1"
    endDate = dateadd("m",1,startDate)
    daysInMonth = dateDiff("d",startDate,endDate)
end function

This may be a bit of a curve ball; I dont let users enter dates, I give them a pop up calendar to choose dates. There are many benefits to this, in particular - what format is the user going to enter vs the format you are looking for...

Wind is your friend
Matt