Date vba code help me

[noppo123]

Hello friedns;

selects only specified dates in cell G3-G4
does not select date range


19.05.2019 - 21.05.2019 why doesn't choose date between 20.05.2019

please help me

Sub tar()



    ActiveSheet.PivotTables("PivotTable1").CubeFields(39).EnableMultiplePageItems _
        = True
Tarih = Format(Range("G3"), "yyyy-mm-dd") & "T00:00:00"
Tarih2 = Format(Range("G4"), "yyyy-mm-dd") & "T00:00:00"
    ActiveSheet.PivotTables("PivotTable1").PivotFields( _
        "[TakvimUL].[Yıl -  Hafta -  Gun].[Yıl]").VisibleItemsList = Array("")
    ActiveSheet.PivotTables("PivotTable1").PivotFields( _
        "[TakvimUL].[Yıl -  Hafta -  Gun].[Hafta]").VisibleItemsList = Array("")
    ActiveSheet.PivotTables("PivotTable1").PivotFields( _
        "[TakvimUL].[Yıl -  Hafta -  Gun].[Gun]").VisibleItemsList = Array( _
        "[TakvimUL].[Yıl -  Hafta -  Gun].[Gun].&[" & Tarih & "]", _
        "[TakvimUL].[Yıl -  Hafta -  Gun].[Gun].&[" & Tarih2 & "]")
End Sub

 

[vletm]

noppo123
Question: Why...?
Answer: Your Array seems to have two values from cells G3 and G4.

 

[noppo123]

How can I get the range
does not select all dates in the date range

 

[vletm]

noppo123
Someone else would answer 'how..'.
So far, it is not range.

 

[noppo123]

Will you help?

 

[vletm]

noppo123
Did You read my previous reply's the 1st sentence?
There are others, which likes Arrays... more than I.

 

[noppo123]

send it as code i don't fully understand you

 

[vletm]

noppo123
Seems that You neither read sentence ... 'Someone else...'.

Your Array has TWO values (19.05.2019 AND 21.05.2019) - okay?
but seems that You would like to have values FROM (19.05.2019) TO (21.05.2019) - okay?
You have to tell that to Excel the way Excel would understand it.

Now, You're asking code ...
You should upload a sample Excel-file,
that someone would check/verify that Your code would work after make it work.
I won't even start to thinking this more, if I cannot check/verify that it would work!

 

[noppo123]

( Your Array has TWO values (19.05.2019 AND 21.05.2019) - okay? ) YES

( but seems that You would like to have values FROM (19.05.2019) TO (21.05.2019) - okay? ) YES İ WANT İT


but the excel file does not work in your turn when it pulls sql based data ( data it only works on me )
my english sucks sorry for exhausting you

 

[vletm]

noppo123
Why did You upload a file which do not have Your code?
Which Excel-version do You use?
.... because Your 'Pivot-table' seems NOT work with my version.