>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
- Ravi
True greatness consists in being great in little things.
- Charles Simmons