troubleshooting Question

Crystal Reports: Best way to write a time query

Avatar of Maliki Hassani
Maliki HassaniFlag for United States of America asked on
Crystal Reports
3 Comments1 Solution454 ViewsLast Modified:
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_START_TIME, 'US/Eastern') + INTERVAL '1' HOUR) < UDF_CONVERT_UNIX_DATETIME(DATE_CREATED, '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_ACTUAL_START} < {EVENT_TABLE.TKT_DATE_CREATED}) by 1 hour Then
    'Greater than 1 hour'
else
    'Less than 1 hour';
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros