>>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

What's the ActiveX control you're using? Cetin, mentioned one that doesn't have the properties you mentioned.