Pivot table variable problem

[van_65166]

Hello

Is it possible to make the date part variable in the vba code below? I would like your help.

>>> use code - tags <<<

ActiveSheet.PivotTables("PivotTable1").PivotFields("Yaratma tarihi"). _
PivotFilters.Add2 Türü:=xlBefore, Değer1:="20.01.2025"

sample file

TEST KÄ°TAP.xlsm

drive.google.com

 

[vletm]

van_65166​

It's many time smoother for others to send an Excel-file here than link to somewhere.

 

[van_65166]

van_65166​

It's many time smoother for others to send an Excel-file here than link to somewhere.

HELLO, DON'T HOLD IT AGAINST ME, I WILL BE MORE CAREFUL, GOOD LUCK
Moderator Note: Please check that Your CapsLock-button works well. Only capital letters means shouting.

 

[vletm]

van_6516​

Your sample file misses 'Pivottable1'.
You could try to modify Your code like below.
ActiveSheet.PivotTables("PivotTable1").PivotFields("Yaratma tarihi").PivotFilters.Add2 Türü:=xlBefore, Değer1:= date1
... and You have to add one more line before above line - which gives value for date1

 

[van_65166]

çok teşekkür ederim işe yaradı harikasın
thank you so much it worked you are great