Problem in Date Formating

[Anonymous]

I have a numeric string of date which i loaded in my application. when i am writing expression "date(Date,'MMM-YY')" . Date is showing in correct format in graph but when i am exporting it as excel(send to excel) , date is in numeric. is there any way to get it in right format.

[#2]

Hi samay!

I think that will only change the date format in QlikView graph, but not when you exported it. I suggest you to make official date format in your script that you will use. Like:

date(Date, 'MMM-YY') as myDate

And the use "myDate" for your Table and Graphs..

Hope that can help you solve your problem

-Lester

[Anonymous]

Hi Iprosete ,

Thanks for your reply. i have tried your solution but it is not working.Here is my Qlikview file.

http://community.qlik.com/media/p/117910.aspx

[#4]

Hi Samay!

Yeah, I saw your QV file and I was surprised that you posted your .qvw to "Shared QlikViews".. Anyways, I can' t see the original date format since it is not attached, so I'm giving you other solution for your problem. I added a "Fast Type Change" on your Graph, its now Line Graph and Straight Table. Switch to Straight table first before exporting it to Excel.

I already tried it and it worked.. And I think adding one click isn't a problem..

- Lester

[#5]

HI

DO LIKE THIS

DATE#(DATE, 'MM/DD/YY') AS MYDATE AND U WILL GET THE DATE FORMAT

REGARDS

ABDALLA

[sathishkumar_go]

Hi

Try this date#(Date,'Date Format','MMM-YY') AS Date

-Sathish

[Anonymous]

Hi Lester,

Thanks very much - that'll do it!.

[Anonymous]

Satish,

Thanks for your reply but Your solution is not working. it is showing error in script.

[sathishkumar_go]

Hi Samay,

Can u attach ur application here?

-Sathish

[Anonymous]

Hi Abdullah,

Thanks for your reply but Your solution is not working. When i am expoting the data from excel, date format comes in numeric value.