>Sort of the YEAR() and MONTH() functions take a date or date/time parameter. The function you need for the day value is the DAY() function which also takes a date or date/time value as a parameter.

Hi George - Thank yu fro your response. I tried what you and Sergey suggested and got some error message such as:

Member YEAR does not evaluate to an object - and the same for MONTH and DAY.

- Ravi