Incorrect data showing when duplicate dates in cross table

[renjithpl]

HI all,

I have used crosstable for my data,

but someplaces in my table i have date fields twice (eg. 15-Aug-2010)

when i execute, i am getting something like this. 2/6/3007

How to tell qlikview to read both dates as one date and add data from both dates.

Thanks in advance

Ren

[#2]

Ranjit, wouldn't it work to load distinct dates in your script? tx, S