Need Advice

[#1]

Hi All,

The format of date is like this [42040],[42041] while loading the data from excel, prior to loading the format of the data in excel is 16-03-2015,15-06-2015.etc..I have formatted cells to date in excel n tried all the possibilities in excel...Is there any option where we can load date as it is...please advice..

Regards,

Krishna

[Anonymous]

Use date() function when load this field.

[robert_mika]

What you see in Excel is just format.

Excel stores Dates as values numbers.

Use Micheal advice.

[#4]

Hi Robert & Michael,

The problem here is I'm able to convert these stuff to proper date format in qlikview, but while using triggers, I'm facing  issues...When I'm trying to select set of dates with the selection of some value in another list box... its not happening..

I have used the following expression as trigger

Regards

Krishna

[maxgro]

instead of trigger you can try with Rob solution here

http://community.qlik.com/message/732989#732989