Crystal Reports Converting number field to date

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

Topic: Converting number field to date

Author	Message
Jeanette Newbie Joined: 26 Feb 2008 Location: United States Online Status: Offline Posts: 8	Topic: Converting number field to date Posted: 26 Feb 2008 at 3:36pm
	Today is my first day with "Crystal Reports 9 for DUMMIES" so I am obviously new to Crystal. Trying to pull data from our accounting software and the date the order was placed pulls as "12327464". The field shows it is a number field and I don't know how to convert to a date. Can anyone help? Thanks.
	Jeanette B
	IP Logged

rahulwalawalkar Senior Member Joined: 08 Jun 2007 Location: United Kingdom Online Status: Offline Posts: 731	Posted: 27 Feb 2008 at 2:09am
	Hi, Check the posting by http://www.kenhamady.com/form02.shtml I tested using the formula and got the result as follows ,please let me know if it is correct 01/01/1959 12327464 Can you post few more numbers........ Cheers Rahul
	IP Logged

Jeanette Newbie Joined: 26 Feb 2008 Location: United States Online Status: Offline Posts: 8	Posted: 27 Feb 2008 at 6:47am
	Thank you!! The link you sent is wonderful because it specifically mentions Macola Accounting which is what I am working with! My choice of numbers was very bad. The numbers actually come out as YYYYMMDD so the formula should work. Next newbie questions -- where do I put the formula? Thank you SO MUCH! Jeanette
	Jeanette B
	IP Logged

rahulwalawalkar Senior Member Joined: 08 Jun 2007 Location: United Kingdom Online Status: Offline Posts: 731	Posted: 27 Feb 2008 at 6:57am
	Hi, Put the formula in details section hope i.e. where you want.? Cheers Rahul
	IP Logged

Jeanette Newbie Joined: 26 Feb 2008 Location: United States Online Status: Offline Posts: 8	Posted: 28 Feb 2008 at 11:46am
	Just wanted you to know that I finally did it! Converted the number to a readable date. While you said to put it in the detail section, I didn't realize that you had to drag the icon into the detail section. Ithought putting the formula in was adequate. Just wanted to say thank you again. Jeanette
	Jeanette B
	IP Logged

rahulwalawalkar Senior Member Joined: 08 Jun 2007 Location: United Kingdom Online Status: Offline Posts: 731	Posted: 29 Feb 2008 at 6:50am
	Great Work ..... Cheers Rahul
	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.033 seconds.