Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Select Expert Formula Post Reply Post New Topic
Author Message
AndrewD73
Newbie
Newbie


Joined: 28 Nov 2013
Online Status: Offline
Posts: 2
Quote AndrewD73 Replybullet 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 IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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 IP Logged
AndrewD73
Newbie
Newbie


Joined: 28 Nov 2013
Online Status: Offline
Posts: 2
Quote AndrewD73 Replybullet Posted: 28 Jan 2015 at 12:21am
That's great. Thanks for your help with this!
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.031 seconds.