Discount calculation rule ends 5 hours off

[rainman2000]

Hi All,

I'm using Joomla 2.5 and VM 2.0.22b (can't upgrade yet). I am located in Eastern Time Zone and my server is located in Eastern Time Zone (GMT-5). I have Joomla configured for New York time. My discount calculation rules end when there is still 5 hours remaining for the discount. It's OKay at 5 hours and 1 second, but when it reaches 5 hours it ends the discount so it seems this is related to the 5 hour offset somewhere in Virtuemart. However, my order transactions all have the correct times on them. Please advise.

Thanks!

[rainman2000]

So, obviously the ending the discount at UTC/GMT time but how do I make it end at the server's local time? This is critical as we have a sale coming up Tuesday to use this so any help is greatly appreciated.

Thanks!

[Milbo]

Check the code if the offset is used.

[rainman2000]

Thanks Milbo,

Okay so it was actually the timer integrated with Virtuemart that was the problem and not Virtuemart. Since the time shown in the database is UTC/GMT I was able to just move it forward 5 hours to convert it to Eastern Time and then add offset code in the timer and it works fine. 

[Milbo]

So your offset in joomla was not set correctly?