Crystal Reports Formula for subtracting time from a datetime field

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Formula for subtracting time from a datetime field

Post Reply

Post New Topic

Author	Message
rkittu2k7 Newbie Joined: 05 May 2009 Location: India Online Status: Offline Posts: 15	Topic: Formula for subtracting time from a datetime field Posted: 07 Mar 2011 at 6:46pm
	I have a field that is formatted as a datetime field. I just need to know how to subtract 3.5 hours from this time. How do I write a formula in crystal reports kindly help me. Thanks in advance Ramakrishna Reddy
	IP Logged


FrnhtGLI Senior Member Joined: 22 May 2009 Online Status: Offline Posts: 347	Posted: 08 Mar 2011 at 2:22am
	dateadd("n", -210, {table.datetimefield})
	\|< /\ '][' ( )
	IP Logged

rkittu2k7 Newbie Joined: 05 May 2009 Location: India Online Status: Offline Posts: 15	Posted: 08 Mar 2011 at 5:55pm
	the above formula worked fine for me thank you very much
	IP Logged

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