https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Add-in-Proper-format-of-date-for-Drill-Thru-data-in-Pivot/m-p/75763#M1050 We have several pivot tables using the Add-in where when selecting a cell to drill-thru for details will only provide the date by default as a number. <BR /> <BR /> We must reformat it in the worksheet each time to display the date properly. <BR /> <BR /> If the variable is display in the pivot table, it is displayed as date.<BR /> <BR /> What is missing to enable auto formatting for the cell drill-thru detail to provided date variables as dates ?<BR /> <BR /> What format (or not) should the date variables be ?<BR /> We have contacted tech support on this question and never recieved an response that has solved our problem. Message was edited by: jrmathieu Wed, 14 Oct 2009 21:09:30 GMT jrmathieu 2009-10-14T21:09:30Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Add-in-Proper-format-of-date-for-Drill-Thru-data-in-Pivot/m-p/75763#M1050 We have several pivot tables using the Add-in where when selecting a cell to drill-thru for details will only provide the date by default as a number. <BR /> <BR /> We must reformat it in the worksheet each time to display the date properly. <BR /> <BR /> If the variable is display in the pivot table, it is displayed as date.<BR /> <BR /> What is missing to enable auto formatting for the cell drill-thru detail to provided date variables as dates ?<BR /> <BR /> What format (or not) should the date variables be ?<BR /> We have contacted tech support on this question and never recieved an response that has solved our problem. Message was edited by: jrmathieu Wed, 14 Oct 2009 21:09:30 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Add-in-Proper-format-of-date-for-Drill-Thru-data-in-Pivot/m-p/75763#M1050 jrmathieu 2009-10-14T21:09:30Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Add-in-Proper-format-of-date-for-Drill-Thru-data-in-Pivot/m-p/75764#M1051 Is there any best practices to use for dates within the Add-in, Excel and pivot tables ?<BR /> Thank you,<BR /> John Mathieu Fri, 07 May 2010 11:39:53 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Add-in-Proper-format-of-date-for-Drill-Thru-data-in-Pivot/m-p/75764#M1051 jrmathieu 2010-05-07T11:39:53Z