ddrake
Technical User
- Mar 19, 2003
- 92
Hi!
Using Crystal 8.5 hitting a SQL2K db. (ARS 5.1.2) Havin' an issue with the selection formulae. Need to pull out 90 days of cases (it's a Remedy database), but only those created between midnight and 5am. This is my formulae:
({HPD:HelpDesk.Create Time} in Aged0To30Days OR
{HPD:HelpDesk.Create Time} in Aged31To60Days OR
{HPD:HelpDesk.Create Time} in Aged61To90Days) and
(Hour ({HPD:HelpDesk.Create Time}) in [0, 1, 2, 3, 4, 5])
Create Time is a DateTime field. When I check the formulae, it says that "a string is required here" and puts the cursor in front of the Aged0To30Days function...
Thank you!!
Using Crystal 8.5 hitting a SQL2K db. (ARS 5.1.2) Havin' an issue with the selection formulae. Need to pull out 90 days of cases (it's a Remedy database), but only those created between midnight and 5am. This is my formulae:
({HPD:HelpDesk.Create Time} in Aged0To30Days OR
{HPD:HelpDesk.Create Time} in Aged31To60Days OR
{HPD:HelpDesk.Create Time} in Aged61To90Days) and
(Hour ({HPD:HelpDesk.Create Time}) in [0, 1, 2, 3, 4, 5])
Create Time is a DateTime field. When I check the formulae, it says that "a string is required here" and puts the cursor in front of the Aged0To30Days function...
Thank you!!