Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Select 24 Hours data for 6am yesterday to 6am Post Reply Post New Topic
Author Message
vitot
Newbie
Newbie
Avatar

Joined: 14 Nov 2016
Location: United Kingdom
Online Status: Offline
Posts: 3
Quote vitot Replybullet Topic: Select 24 Hours data for 6am yesterday to 6am
    Posted: 15 Nov 2016 at 12:07pm
Hi, I am trying to run a report for the actions took place within last 24 hours starting from 6am yesterday to 6am current date. There are 3 shifts in a day 6am - 2pm, 2pm - 10pm and 10pm - 6am.

I am trying to capture the transactions took place during these shifts. Report will run 7:30 but it should only capture the data between 6am to 6am.

The table has transactiondate and tansactiontime fields. I know these could easily be merged into one field trough a formula.

Any help would be really appreciated.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 16 Nov 2016 at 7:43am
(table.transactiondate = today-1 and table.transactiontime>= time(6,0,0))
Or
(table.transactiondate = today and table.transactiontime < time(6,0,0))
IP IP Logged
vitot
Newbie
Newbie
Avatar

Joined: 14 Nov 2016
Location: United Kingdom
Online Status: Offline
Posts: 3
Quote vitot Replybullet Posted: 18 Nov 2016 at 8:20am
Thank you DBlank. This will work! Thank you for all the help.
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.016 seconds.