HELP! 3 & 4 Digits in data... need all to be 4 Digits 415 = 0415

[christiancorley]

My data has card expiration as 415 and 1213. Need resulting data to have all four digits, so 415 (means April of 2015) to be 0415, but leave 1213 as is since it is four digits.

I can do this in Excel in 5 seconds, but can't figure out in Crystal. HELP!
Tx!
Christian

 

[IdoMillet]

ToText({your_number}, '0000')

Cheers,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[christiancorley]

YOU ARE MY HERO! Worked perfectly. Thank you!!!!

 

[SkipVought]

BTW, they are more than likely NOT the same result as in Excel, but the difference may, and I repeat, MAY be irrelevant.

In Excel you probably gave your number column a NUMBER FORMAT that DISPLAYED leading zeros. But if your number were 415 with leading zeros to 4 digits, the underlying value would still be the NUMBER 415. However, the solution given you in CR, actually converts the NUMBER 415 to CHARACTERS 0415, which is an ENTIRELY DIFFERENT VALUE!

now for your report it may be a distinction without a difference. But "caveat emptor!"

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}