Hi Cathy:
James suggested I do a transform on the date during the concat and it worked. Kindly take a look at one of my responses to Sergey in this thread regarding the printing position of a field. Your input will be appreciated. Thanks.
>Double-check the report definition and make sure that it is really printing "Date1" as you expect. Another thing to do is confirm that the cursor is correct by putting a BROWSE in the code just after you do the massive SQL SELECT. It may be that the cursor is correct but you are accidentally printing the wrong field.
>
>Cathy
>
- Ravi
True greatness consists in being great in little things.
- Charles Simmons