I will like to use the getdate function
only to receive part of the date:

eg. 2002-11-13.

I cannot use the substring function because it's not valid for datetime datatypes.

Any ideas or suggestions.

Thanks, Vic