Crystal Reports BigInt to DateTime

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

Topic: BigInt to DateTime

Author	Message
mdub Newbie Joined: 27 Jul 2009 Location: United States Online Status: Offline Posts: 1	Topic: BigInt to DateTime Posted: 27 Jul 2009 at 2:18pm
	Hi! I am trying to convert an bigint field to a date or datetime field and am not having any luck at all. Can anyone point me in the right direction? Thank you!!
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 27 Jul 2009 at 3:23pm
	If i understand you correctly chances are you need to do a dateadd using the field but you need to know the interval and what the starting datetime is. ... dateadd(interval type,{table.field},startdatetime)
	IP Logged

lalakeyorai Newbie Joined: 01 Nov 2009 Online Status: Offline Posts: 19	Posted: 03 Nov 2009 at 7:14pm
	if you still didnt find any solution, try this: dateadd ("s", {field.name}/ 1000, #1/1/1970#)
	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.000 seconds.