converting date

[Oded Kovach]

Hello there

I got excel file. In the excel file the date is in format DD-MMM-YY.

It accept as string

How can i build an append query that convert this format to date?

any help would be useful

 

[Guest]

Hi,
Try lookup CDate. It should convert any date string to a date type.