Crystal Reports Need a crystal formula

Report Design

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

Topic: Need a crystal formula

Post Reply

Post New Topic

Author	Message
avishalpatil Newbie Joined: 24 Dec 2010 Online Status: Offline Posts: 13	Topic: Need a crystal formula Posted: 29 Sep 2011 at 11:07pm
	Hi , I am having some "Time" field in my table with varchar datatype.Its carrying value like 2.35E5.Its something like (2.35 rest to power 5) I need to convert this string into complete digits.Can anybody please tell me the crystal formula so that i can convert this string into number. Regards Vishal
	IP Logged


lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4374	Posted: 30 Sep 2011 at 3:50am
	it is in scientific notation, is stands for 2.35 x 10^5 or 23500. I would guess is the number of seconds from some arbitrary date, though it only works out to a little over 2 days. if it was minutes it would be about 16 days, and if it is days, it would be about 64 years. HTH
	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