>>I have a cursor with a date field in it. I need to save this cursor as a CSV file so..........
>>
>>COPY TO (myFile) CSV
>>
>>but........
>>
>>the date field is saved as MM/DD/YYYY and the user needs it in DD-MMM-YY format. Is there a reasonably easy way to make this format change???? (I've tried various SET DATE settings but didn't seem to get what I need)
>>
>>I haven't yet tried it (task for tommorrow or Thursday) but the next attempt is going to be
>>
>>save as XLS
>>open an instance of Excel
>>load the file (where it displays as desired)
>>and then SaveAs CSV from Excel
>>
>>Any thoughts on if this should work and/or suggestions for a better approach are appreciated.
>
>One way would be to create another C( 9 ) column ( "CharDate" ) in your cursor and populate it from the date field ( "MyDate" ) via a UDF:
>
>REPLACE ALL CharDate WITH DD_MMM_YY( MyDate ) IN MyCursor
>
>* FUNCTION DD_MMM_YY
>LPARAMETERS ;
> tdDate
>
>RETURN ;
> PADL( LTRIM( STR( DAY( tdDate ) ) ), 2, "0" ) ;
> + "-" ;
> + SUBSTR( CMONTH( tdDate ), 1, 3 ) ;
> + "-" ;
> + RIGHT( LTRIM( STR( YEAR( tdDate ) ) ), 2 )
>
Thanks for taking the time to respond.
I had thought about that but, unfortunately, the user has a macro which depends upon certain data being in specific formats and specific columns.