Convert Number to Date

[kutoose]

I have a database field in 'Number format'. I need to convert it to date.

The number is of format YYYYMMDD. For example 20050920 stands for 2005/09/20. I could not find a function which directly do the conversion. Can any one help me with a formula which convert it to date ?

Crystal Reports Version XI

Thanks

 

[dgillz]

NumbertoDate() is the function.

I thought this was a part of Crystal XI, hoever if it is not then you can download the .dll for this from the business objects website.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[kutoose]

I found this link useful

http://www.hammerapps.com/techtips/techtipsasp/techtipsdynamic.asp?TTID=156

 

[synapsevampire]

Try aformula of:

whileprintingrecords;
stringvar MyDate: = totext({table.datefield},0,"");
cdate(val(left(Mydate,4)),val(mid(mydate,5,2),val(mid(mydate,7,2))

Replace {table.datefield} with your date field.

-k

 

[mirage10]

u can use pwformatdate() function

------------------------------------------
A Man can be only as happy.. as he makes up his mind to be