Converting number to Date ( data coming from AS400) 1

[old123]

Iam using CR ver 9 to pull data off from AS400 . date field come over as a numeric (eg. 50601 which is 1st june 2005 )I need to convert this number 50601 to date 06/01/2005. i was trying to use numbertodate function which i downloaded from other site but did'nt work. Any help ........Iam new to crystal reports

 

[vidru]

Try something like this, which uses a combination of the Mod and Int functions to break apart portions of the number field to represent year, month, and day:

//I'm using the variable 'dt' for clarity...
NumberVar dt := {Table.NumericDateField};
Date(Int(dt/10000) + 2000, Int((dt Mod 10000) / 100), dt Mod 100)

Are all of your years 2000 or greater?

-dave

 

[dgillz]

NumbertoDate({YourNumber}+20000000)

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

http://www.gainfocus.biz

 

[old123]

i tried this formula CDate(ToNumber(Left(CStr(50601, 0), 1)) + 2000, ToNumber(mid(CStr(50601, 0), 2, 3)), ToNumber(Right(CStr(50601, 0), 2)))

it worked. as all the years & in 2000. Thanks

 

[old123]

This NumbertoDate({YourNumber}+20000000) worked too.

this is easy one. thank you guys.