Crystal Reports Grouping by Transaction Date/Time

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Grouping by Transaction Date/Time

Post Reply

Post New Topic

Author	Message
ewhite Newbie Joined: 26 Jul 2012 Location: Australia Online Status: Offline Posts: 2	Topic: Grouping by Transaction Date/Time Posted: 26 Jul 2012 at 4:55pm
	I have a POS sales database and each transaction has a sales date. The issue i am having is that i want to group all sales between 7am and 6.59am the next day into one date. When I group by sales date all transactions after midnight are added onto the next day. Any help would be appreciated....
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 27 Jul 2012 at 9:37am
	use the dateshift() function to move your value by 7 hours, group on that formula result but display the original data field Edited by DBlank - 27 Jul 2012 at 9:37am
	IP Logged

ewhite Newbie Joined: 26 Jul 2012 Location: Australia Online Status: Offline Posts: 2	Posted: 29 Jul 2012 at 7:22pm
	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
	IP Logged

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum