Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Wrong date format when export to Excel

Hello

when I just use date field from Dimension and export the table to excel everything working well.

but as soon that I am using a formula

=if(date> actual,date)

When Actual is a variable ==> 1/2/2015

and export to excel than the format in excel not ok.

I mean when I am filtering the date I don't see group like we should see for date "Year / month and than date"

but I see a lot of lines of date, You can see the picture attached.

I don't know what to do.

I hope that it was clear

thanks

Franck

1 Solution

Accepted Solutions
Highlighted
mwoolf
Honored Contributor II

Re: Wrong date format when export to Excel

Your dates are coming into Excel formatted as Text.

To convert in Excel, click column A and chcnge the format to Short Date.

Then select Data|Text to columns and click Finish

Instead of using Send to Excel:

     If you are using the IE PlugIn, you can right-click and choose Copy to Clipboard|Full Table. Then paste into Excel

     Or

     Right-Click and Export to csv. Then open in Excel.

View solution in original post

2 Replies
Highlighted
mwoolf
Honored Contributor II

Re: Wrong date format when export to Excel

Your dates are coming into Excel formatted as Text.

To convert in Excel, click column A and chcnge the format to Short Date.

Then select Data|Text to columns and click Finish

Instead of using Send to Excel:

     If you are using the IE PlugIn, you can right-click and choose Copy to Clipboard|Full Table. Then paste into Excel

     Or

     Right-Click and Export to csv. Then open in Excel.

View solution in original post

Highlighted
Not applicable

Re: Wrong date format when export to Excel

THANKS A LOT

I was stuck with this during a long time,

HAVE a very nice weekend and thank you again