excel date load issue

[alexpanjhc]

I have an excel file with dates in it and I want those dates as my field name

10/2/2012   10/3/2012.....

when i load the file and make them embeded labels, the date becomes 41212, 41213.

How can I solve the problem?

Thank you!

[Anonymous]

Use Date() around your fieldname. Example:

Load

     *,

     date(DateField, 'MM/DD/YYYY') as DateField

From XYZ

[its_anandrjs]

Hi,

Make date field to your excel column while loading like

Date(YourDateColumn, 'MM/DD/YYYY') as DateColumn

Regards,

Anand

[#4]

Hi

in qlikview 2 interpretation functions are there

date#(),timestamp#()----  These functions convert string date format to number date format

date(),timestamp()---  These functions converts number date format to string date format

in ur case use the date()

date(fieldname) as dates

use in ur script

then it converts 41212, 41213 in to 10/2/2012   10/3/2012..

if u need 10/2/2012   10/3/2012.. into 41212, 41213

use the date#(fieldname) as newfield

[alexpanjhc]

Sorry i guess I was not clear at all...

My problem is here is the original excel like this for a month

                              oct-2-2012   oct-3-2012  oct-4-2012   oct-5-2012  oct-8-2012............

email received:          20               30               40               25                    32  .....

tickets received:        7               8                    9                 5                    12....

then i need to have a weekly table like this

                              oct-5-2012   oct-12-2012.....

email received        29                    33

tickets received      115               202

I thought I could just sum everything, but then the week is an issue and the hard part for me is that how can I identify what week of the month is that date belongs to? since the dates would be field name.

when i load the dates,they becomes numbers, but i cant load them using date functions because i do not want the actual numbers get changed.

Hope this is a bit clear.

Thanks