Hi,
I have a pivot table in sheet1 of a workbook. And the source data is from sheet2 (with 5 columns, 5th column is date and the column format is "mm/dd/yyyy"). But whenever I refresh the pivot table, i want the format should be mm/dd/yyyy. but based on date the filter value is showing as d/m/yyyy.
strdate = Format(Now, "MM/DD/YYYY")
ActiveSheet.PivotTables("QcSummaryPivotTable").PivotFields("Last Run Date in IST"). _
CurrentPage = strdate
PS: If the date has two digits for both day and month (31/12/2012). Its working fine. But getting error if the date is like 10/1/2012, 1/12/2012, 1/1/2013.
Your suggestions please.
I have a pivot table in sheet1 of a workbook. And the source data is from sheet2 (with 5 columns, 5th column is date and the column format is "mm/dd/yyyy"). But whenever I refresh the pivot table, i want the format should be mm/dd/yyyy. but based on date the filter value is showing as d/m/yyyy.
strdate = Format(Now, "MM/DD/YYYY")
ActiveSheet.PivotTables("QcSummaryPivotTable").PivotFields("Last Run Date in IST"). _
CurrentPage = strdate
PS: If the date has two digits for both day and month (31/12/2012). Its working fine. But getting error if the date is like 10/1/2012, 1/12/2012, 1/1/2013.
Your suggestions please.