Date of Birth Displayed as a 810,109

[cknapp]

I need to have this date displayed as 01/09/81 on my crystal report. The field in the database is defined as a number.

 

[Naith]

Create a couple of formulae:

//@Formula1
totext({numerical_date_field},0)

//@Formula2
whileprintingrecords;
numbervar yr;
numbervar mn;
numbervar dy;

yr := tonumber(mid({@Formula1},1,2));
mn := tonumber(mid({@Formula1},3,2));
dy := tonumber(mid({@Formula1},5,2));

numbervar yr1 := 1900 + yr;

datetimevalue(yr1,mn,dy)

Not really a great fan of hardcoding the year in a formula myself, but being as your database conspicuously has birthdate as year as YY, I'm assuming your whole db birthdates are 19XX...

Naith

 

[mbarron]

Another formula option:

stringvar dat:=totext(19000000+{date.field},0,""
date(val(dat[1 to 4]),val(dat[5 to 6]),val (dat[7 to 8])) Mike