Convert to date format
How do I convert the given number to date format e.g. 2009062 should result in 03-Mar-2009. where 2009 is the year and 062 is the number od days. 62th day is 3rd march.

Answer Question   |  June 19, 2009  10:08 AM
convert, date format () dd-mmm-yyyy error

Excel Date format () dd-mmm-yyyy error from exported crystal report
I am exporting a crystal report file to excel and date field TRADE_DATE is coming out strange. i.e PARTY_ID TRADE_DATE CX () 16-Jul-2003 CX 29-Jul-2003 CX 09-Dec-2003 Some trade_date fields are in Custom Type “dd-mmm-yyyy” format ( which is the correct format) but some are in Custom Type “() dd-mmm-yyyy” format which is incorrect. I [...]

Answer Question   |  March 24, 2008  7:30 PM
Crystal Reports, date format () dd-mmm-yyyy error, Excel 2003