Maliki Hassani
asked on
Crystal Reports: Best way to write a time query
Hello Experts,
I am trying to duplicate a query that is in SQl to Crystal syntax. I am trying to get a true or false for the following:
Event_Start_Time is greater than 60 minutes from the Ticket_Create_Date. In SQL the where clause looks like:
FROM EVENT_TABLE
WHERE (UDF_CONVERT_UNIX_DATETIME (EVENT_STA RT_TIME, 'US/Eastern') + INTERVAL '1' HOUR) < UDF_CONVERT_UNIX_DATETIME( DATE_CREAT ED, 'US/Eastern')
If I knew how to write the + interval '1'Hour I could figure it out. The table output is in unix time or I can have it as a date_time format. I have views that changes the format.
if ({EVENT_TABLE.TKT_DATE_ACT UAL_START} < {EVENT_TABLE.TKT_DATE_CREA TED}) by 1 hour Then
'Greater than 1 hour'
else
'Less than 1 hour';
I am trying to duplicate a query that is in SQl to Crystal syntax. I am trying to get a true or false for the following:
Event_Start_Time is greater than 60 minutes from the Ticket_Create_Date. In SQL the where clause looks like:
FROM EVENT_TABLE
WHERE (UDF_CONVERT_UNIX_DATETIME
If I knew how to write the + interval '1'Hour I could figure it out. The table output is in unix time or I can have it as a date_time format. I have views that changes the format.
if ({EVENT_TABLE.TKT_DATE_ACT
'Greater than 1 hour'
else
'Less than 1 hour';
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent! Thank you again!
ASKER