conversion of general to date format

[#1]

Hi All,

            I am trying to load data from excel sheets. The data contains date fields in (18-APR-08 12.00.00.000000000 AM) this format. In excel its the general format. I want to convert this data  into date format into qlikview and then use date functions. How can I do this??? Please suggest some way to acheive this.

[#2]

If you dont want time, use

date#(date_field,'DD-MMM-YY')

for date and time use timestamp#()

Kiran.

[#3]

I have tried using it but doesnt seem to work. It gives me data as it is.. Attaching a small example of data..

[#4]

Can you share a sample of field in excel?

Try with: date#(left(trim(date_field),9),'DD-MMM-YY') as date

Kiran.

[#5]

I have tried the above solution but no use.. Please find the sample of data attached in above reply. See if that helps you..

[#6]

It seems to work for me.

Kiran.

[#7]

found a solution for the problem..

Thanks Kiran for the above suggestions......