Problems w/ Utldate.dll

[TheMagikWand]

hey guys/gals, i installed the "numbertodate dll" from the crystal website and when i went to create a formula to turn my 8-digit date (exe. 19990105 to Jan 5, 1999) it told me a needed to insert a number.

heres my formula (it really doesnt get any easier):

numbertodate({xxx.date})

it was asking me for a number inbetween the first parenthesis and the first bracket

any ideas???

 

[IdoMillet]

No need for a special dll.

Use a formulas such as:
---------------------------------------------------------
CDate(CDbl(ToText({your_number},0,'')[1 to 4]),CDbl(ToText({your_number},0,'')[5 to 6]),CDbl(ToText({your_number},0,'')[7 to 8]))
---------------------------------------------------------

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[crystalreporting]

The date field in your database must be defined as something other than a number - hence the formula error you are getting. Do as Ido suggests, or use NumberToDate(ToNumber({xxx.date})). It would probably help if you could determine how the date field was being stored in your database e.g. String, Number etc.

Peter Shirley

http://www.linkcorp.com

 

[TheMagikWand]

wow for your help guys, as it turns out my field was stored as a string rather than a number field, problem solved.