Crystal Reports Logic to include timing (+1hr)

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design

Topic: Logic to include timing (+1hr)

Author	Message
znis Newbie Joined: 18 Apr 2010 Location: Singapore Online Status: Offline Posts: 1	Topic: Logic to include timing (+1hr) 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
	IP Logged

FrnhtGLI Senior Member Joined: 22 May 2009 Online Status: Offline Posts: 347	Posted: 21 Apr 2010 at 2:31am
	dateadd('h',1,({Event Date (GMT)}))
	\|< /\ '][' ( )
	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.