CRXI
I have a string field in the report which is a date. It can be 040209 for April 2nd, 2009. When the report is exported to CSV format, the field becomes as 40209. I need it as 040209.
I tried to convert it to number or date, but when the rpt. file is exported to CSV format it becomes 40209 instead of 040209.
Can you help me how to work around and make displayed leading zero if the month from 01 to 09?
Thanks
I have a string field in the report which is a date. It can be 040209 for April 2nd, 2009. When the report is exported to CSV format, the field becomes as 40209. I need it as 040209.
I tried to convert it to number or date, but when the rpt. file is exported to CSV format it becomes 40209 instead of 040209.
Can you help me how to work around and make displayed leading zero if the month from 01 to 09?
Thanks