Print Page | Close Window

Logic to include timing (+1hr)

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9760
Printed Date: 20 May 2024 at 3:18am


Topic: Logic to include timing (+1hr)
Posted By: znis
Subject: Logic to include timing (+1hr)
Date Posted: 20 Apr 2010 at 8:44pm

hi! i have an enquiry to check on how to create a formula that helps to add 1hr to my final output. Currently my logic looks like this:

"if {Event Code} = "IPKD" then ({Event Date (GMT)}) else date(1900,1,1)

so the answer from this logic, i want to add 1hr.
 
how shd i revise the logic...
 
Pls help......


-------------
Thanks Zni



Replies:
Posted By: FrnhtGLI
Date Posted: 21 Apr 2010 at 2:31am

dateadd('h',1,({Event Date (GMT)}))



-------------
|< /\ '][' ( )



Print Page | Close Window