Convert the integer to date format(MMM-YY)

[#1]

Hi All,

I have a scenario where i read data from the excel spreadsheet which has a date column of format(MMM-YY), but it is interpreting the data present in that column as an integer as [40179]  for JAN-10.  In This case how do i proceed as to get the desired output in the MMM-YY format.

Regards,

surman

[sdmech81]

Hi,

For that there is small check as suggested by HIC,

When u add your date filed in to list box,If values are falling on to the right side of list box then its correct and you can use date function.

If values are falling left side of list box then Qlikview take it as String..

Get this PDF,,it will help on Date related query in qlikview by HIC..(PFA)

Sachin..

[chandu441]

Thanks for posting correct solution for this issue which is causing while loading excel file with date format MMM-YY through cross table load we are getting issue with the format as you mentioned.

=Date(PurgeChar( MonthYear , '[]' ),'MMM-YY')