Date issue with Excel Export

[Anonymous]

Hi Guys,

I have written a function to load only Jan 2017, feb 2017, jan 2018, feb 2018 from my QVD, I get correct result.

But after adding all the columns in table box  when I export , I get extra date appearing in the excel other than Jan and Feb. How to resolve this?

[mayankraoka]

Try this...

Go to document properties - Numbers.You will find all the dimensions listed on the left.Select your required dimension from the left. And give it the desired format from the right.

This should work.

Regards,

Mayank