>How can I get the number of days in a month.
>
>Thanks
>Andrew

I do this way :

gomonth(xdate ,1) - day(gomonth(xdate ,1))

&& xdate is a Date value
this gives me the last day of the month