Struggling with trying to use VBA to dynamically shift Pivot table filters (tying them to a name variable)

[sx502]

https://imgur.com/a/7StdKxw

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?