Hi Jay,
In table 1 the field is a date and in table 2 the field is a character but it stores a date in the same form mm/dd/yyyy
I thought that using dtoc would allow it to work properly but does this mean it wont't work?
Thanks!
Max

>> Max,

>> I ran this on my system and it worked, so perhaps we have something different in our setups.

>> The first question that comes to mind is this. What data type is the "rptdate" field in your 2 tables. I assumed it was a Date type, but a Time or character string would also be possible. Is the data type the same in both tables?

>> Jay