anyone know how to stop Tzpivots throwing up error - chart perios is greater than 1 day ?
I'm using Alpari uk which is +2 BST so I have local time zone set to 2 and destination time zone set to 0, so this give the start of day as 02:00 which is what I need.
Ive tried setting local as 0 and destinatio as -2, but this produces the same error message.
Any suggestions ?
I'm using Alpari uk which is +2 BST so I have local time zone set to 2 and destination time zone set to 0, so this give the start of day as 02:00 which is what I need.
Ive tried setting local as 0 and destinatio as -2, but this produces the same error message.
Any suggestions ?