I have two field in to tables set to datetime. The field names are "DateReceived" and "DateIssued". When I run either of the below the SQL View runs properly.

CASE PPEBalance.ID WHEN 2 THEN DateIssued + ExpDays END AS ExpDate
Or
CASE PPEBalance.ID WHEN 2 THEN DateReceived + ExpDays END AS ExpDate

When I attempt to use the below I receive an error message stating "Arethmetic: overflow error converting expression to data type datetime".

CASE PPEBalance.ID WHEN 2 THEN DateIssued + ExpDays ELSE DateReceived + ExpDays END AS ExpDate

How can this be changed to work properly?

Rick -

Have you tried converting your date fields in SQL to dates?

CTOD(dateReceived) and CTOD(dateIssued) making the SQL see the date as a date not text.

Both have been changed to "Date" previously but I still have the same error.

I have found the problem. The ExpDays was set to 9999999 as a default for never expiring. This will not work with this many characters. I will work with only six digits or less. I changed it to 999999 and it works properly.

les maisons sont faites de rondins et d'herbes, it would be the best litteral translation but you would not say this way in French, better: "les maisons sont faites de bois et de pailles" or "les maisons sont en bois et en paille" (wood and hay)....
Rei Coupon Code

My gas heater is not working properly. I have it set to a certain temperature and it will shut off before it gets there.
full article