DateShift didn't work in crystal so it got me searching and i found the solution.
ShiftDateTime was what i needed and I did what you said and grouped by my formula.
It took me a while to figure it out but this is what i used.
shiftdatetime ({RegisterSale.SaleDate},"AEST,-960,AEST","")
this put each transaction datetime back by 7 hours and now all is reporting correctly.
Thanks alot for your response.
Edited by ewhite - 29 Jul 2012 at 10:00pm