convert a number to a date

[simoncs]

Hi

I am trying to convert a number to a date in crystal reports 8.5


the field is a "floating field" on the oracle database - which i believe is similar to a number field?

the numbers for the most part is formatted as ddmmyy and so appears on the report as 150106 - i would like to be able to have this as a date so that we can format it accordingly - eg 15-Jan-2006.

The other problem seems to be that sometimes for dates less than 10 there are only 5 numbers eg 50106.


thanks

Simon

 

[synapsevampire]

Yeah, seems OK still, try:

whileprintingrecords;
Datevar MyDate:=trim(totext({table.field},0,""));
// replace table.field above with yours //
if len(trim(MyDate)) = 5 then
cdate(val(mid(MyDate,4,2)),val(mid(MyDate,2,2)),val(left(MyDate,1)))
else
if len(trim(MyDate)) = 6 then
cdate(val(mid(MyDate,5,2)),val(mid(MyDate,3,2)),val(left(MyDate,2)))
else
cdate(0,0,0)

Should get you close.

-k

 

[simoncs]

thanks - but it produces an error when trying to save the formula

"A date is required here"

cursor then rests at end of - Datevar MyDate:=


any ideas?

 

[lbass]

Change it to:

stringvar MyDate

-LB

 

[synapsevampire]

Ooops, thanks, lb.

-k

 

[simoncs]

thanks guys
u rock!