I found it :) 'Jan 11970' should have been 'Jan 1970' . Thanks for the help.
Does this completely eliminate this problem of updating user info?
Jim
At 01:42 PM 1/9/2000 -0800, you wrote:
>DATEDIFF(Day,'Jan
>11970',DATEADD(Day,ma.Extension+ma.OverDue,maExpireDate)) END,
----------------------------
hostmaster@interaxs.net
www.interaxs.net
InterNet Access Network
Voice: 937-461-3660 Fax:937-228-2773
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart