Pivot Table Date Field Filter

[mikeymay]

Within a worksheet (see image below) the selected cell of B4 has the named range of BCR_WC and a date value of 27 Jan 25 is in the cell.

This cell is formatted to a date value.

I have code the manipulates a pivot table to change a filter to the above week commencing date.

The above is returning an error when the filter is set to (All)

When I manually change the filter to the date in the BCR_WC cell (27 Jan 25), this code executes.

Not entirely sure why the date value isn't translating to the VBA code and PT manipulation.

TIA

 

[mikeymay]

using the DateValue function to convert the 'text' date to a date value works

DateValue(Format(Range("BC_WC"), "dd/mm/yyyy"))