| Author |
Message |
AndrewD73
Newbie
Joined: 28 Nov 2013
Online Status: Offline
Posts: 2
|
  
Topic: Select Expert Formula
Posted: 22 Jan 2015 at 11:41pm |
|
Hi All,
I am looking to automate a Crystal 2011 report and therefore require a Select Expert formula that looks at the previous days data between a certain time period.
The details are:
Field name: {Call_Type_Interval.DateTime} in DateTime
Date: currentdate -1
Time Range: (08,00,00) to (22,00,00)
I am quite new to Crystal and cannot seem to get this to work. Any help would be really appreciated.
Many Thanks
|
 IP Logged |
|
|
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 26 Jan 2015 at 5:13am |
|
Datediff('d',{Call_Type_Interval.DateTime},currentdate)=1 and
time({Call_Type_Interval.DateTime}) in time(08,00,00) to time(22,00,00)
|
| IP Logged |
|
AndrewD73
Newbie
Joined: 28 Nov 2013
Online Status: Offline
Posts: 2
|
Posted: 28 Jan 2015 at 12:21am |
|
That's great. Thanks for your help with this!
|
| IP Logged |
|
|
|
