I currently have a process written in VBA that I'm trying to have
automatically run in another DTS package on my SQL 2000 server. Ive made all
the adjustments to the differences in languages but the execution still
haults on:

"INSERT INTO [Latest Data Received] ( DateIn, TimeIn ) SELECT DISTINCT
table_received.*, DateValue([Rdate]) AS DateIn, TimeValue([Rdate]) AS TimeIn
" & _
"FROM table_received " & _
"WHERE (((table_received.RDATE)>=#" & dteImport & "#) AND
((table_received.RDATE)<=#" & dteMax & "#))")

saying DateValue is not a recognized function name.

Isn't DateValue a function in vbscript? How can i fix this? the value in
RDate is a datetime and I need the date part

Thanks.