Thanks to everyone for all of your suggestions. I think I will use
Birgitta/Elvis's suggestion to create a UDF. I was trying to avoid a CASE
statement in order to keep my SQL statement simpler. I did check into
iDate before I posted my message because I thought it might handle it, but
unfortunately it didn't.
This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact