Except for the rounding option for the ToNumber, both examples worked. Now my next problem is to sort the alpha months in the proper order instead of starting with April. Also the following works to
Right({SYBASE.DATEFIELD},2)+"-"+Left({SYBAE.DATEFIELD},4)
mm-yyyy
I have field on a report that prints out 2000101, 2000102, 2000103, ... . This is a string variable on a SYBASE database, being access by ODBC. I need to read the last two characters and put the actual month name in that field. I'm using Crystal Reports Version 7.
Thank You
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.