For additional context.
Basically, I executed the Format code above, and if the targeted named in cell in question (ReportDate1) is not a pivot table filter value, it would generate the correct value 2019-12-31. However, if the cell value IS a pivot table filter value (ReportDate1), it would auto-convert into 43830 (the corresponding date number for the date) and create an error.....how do I make it so that the 2019-12-31 value is directly inserted into the Pivot Table filter value?