Crystal Reports Hardcode time in datetime

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

Topic: Hardcode time in datetime

Author	Message
Yarra Newbie Joined: 13 Dec 2011 Location: United States Online Status: Offline Posts: 10	Topic: Hardcode time in datetime Posted: 24 Feb 2013 at 5:39am
	How can I hard code the 'time' part of the datetime value on a report? e.g When ever the datetime value field has time greater than 7am it should display the actual datetime, if less than 7am it should display the actual date and time as 7:00:00
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 25 Feb 2013 at 4:00am
	if time(field)<time(7,0,0) then date(field)+time(7,0,0) else field
	IP Logged

Yarra Newbie Joined: 13 Dec 2011 Location: United States Online Status: Offline Posts: 10	Posted: 25 Feb 2013 at 5:42am
	worked, thanks!
	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.016 seconds.