B
bbussoloti
Hello, I have an issue that's killing me and I don't know what to do:
- I've created a Pivot Table that reads data from a Sheet in my Book.
- One of the fields is a Date field, formated Custom to "mmm/yyyy"
- I have 2 Combo Boxes (start and end of period) that are filled according
to my PT date fields, on the Worksheet_Activate procedure:
For Each pvtitem In
PivotTables("PivotTend1").PivotFields("Mês").PivotItems
cbxInicio.AddItem (Format(pvtitem.Name, "mmm/yyyy"))
Next pvtitem
(... and same for the End period ...)
- Although my Dates are only from January-07 to December-08 in my PT, the
Combo Boxes shows me only January-09 to December-09 two times (because I had
it from 07 to 08)!
-Even if I try to use .AddItem.pvtitem.Name, the Combo shows my values
correctly, from 07 to 08, but when I try to use those on some calculation, I
find out that they're still beeing treated as 09 dates!
I don't know what to do to solve that, can someone please help?
Thanks.
- I've created a Pivot Table that reads data from a Sheet in my Book.
- One of the fields is a Date field, formated Custom to "mmm/yyyy"
- I have 2 Combo Boxes (start and end of period) that are filled according
to my PT date fields, on the Worksheet_Activate procedure:
For Each pvtitem In
PivotTables("PivotTend1").PivotFields("Mês").PivotItems
cbxInicio.AddItem (Format(pvtitem.Name, "mmm/yyyy"))
Next pvtitem
(... and same for the End period ...)
- Although my Dates are only from January-07 to December-08 in my PT, the
Combo Boxes shows me only January-09 to December-09 two times (because I had
it from 07 to 08)!
-Even if I try to use .AddItem.pvtitem.Name, the Combo shows my values
correctly, from 07 to 08, but when I try to use those on some calculation, I
find out that they're still beeing treated as 09 dates!
I don't know what to do to solve that, can someone please help?
Thanks.