>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 )