Are you sure?

you mean something like: Month("January" & " 1,2006")

Very smart indeed.

-Pam


>coercing dates. You could use:

>Month([MonthName] & " 1,2006")



> What function is used to convert text month to numerical 1-12?
> Thanks
> Jerry