Send To Excel Query

[#1]

Hi Team

Pls refer the attachment. I am doing Sent To Excel from a Table box and from a Pivot.

Problem is with OpenDate field. From Tablebox it contain correct value but doesn't display it in full. From pivot it display value in full but in text format(left side of the cell). If i double click on a cell and then move out of the cell, display willbe like of Tablebox.

I need when i do Send To Excel, it should display the values in date format and in full.

Any workaround.

[disqr_rm]

You can always do this in excel:

Select the range of cells that hold the text dates.
Goto the menu: Data ->Text to Columns
Click Finish

Otherwise, you may have to create a seaparate field and play with it, like storing num(date) and then formating it as date in excel after export.

Hope this helps.