Hi Cathy:
Your idea worked. Thank you.
Here is one part of the code where i am getting the wrong date.
UNION ALL SELECT '6' AS SortKey, 'Consultations' AS Group, ;
'' AS Extra1, '' AS Extra2, '' AS Extra3, ;
'' as Extra4, '' as Extra5, '' as Extra6,;
0 as Extra7, '' as Extra8, '' as Extra9,;
'' as Extra10, CReference as Extra11,;
Daterefer AS Date1, {} AS Date2, {} as Date3, {} as Date4,;
HealthNum, Specialist AS Descr FROM Consultants;
The field DateRefer has the correct date stored in the Consultants Table. However, when I set DateRefer as Date 1 ( as shown above), I get a different date (7/1/1972 instead of 7/20/2003) in the TmpData cursor. Incidently 7/1/1972 happens to be the BirthDate of the patient, but 7/20/2003 is the date stored in the Consultants.DateRefer field.
Thanks Cathy.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons