>Is there a built-in fuction that will return the days in a month from a particular date.
>
>Example:
>
>31 days in 1/2/2000
>29 days in 2/2/2000
>but
>28 days in 2/2/2001
>
>I know I could wite a fucntion which will return the days of the 12 months and to include the function to accomated the leap year. I am lokking for a built-in function.
There is no built in function. Though the result is easily achived by subtracting one from the beginning of the month that follows the desired month e.g.
iDaysInFebruary = DAY( DATE( YEAR(DATE()), 3, 1 ) -1 )
Watch out for December, you will need to use January of the following
year.
censored.