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.
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 "()...