Still getting errors: could it be that the "Right ()" function needs to have some kind of trimming to exclude the hh:mm:ss.mis data? Because it seems that my query to modify the date with the suggested syntax
Code:
(SELECT DateSerial(Right(qryPaymentPostedDate.PostedDate,15),Left(qryPaymentPostedDate.PostedDate,4),Mid(qryPaymentPostedDate.PostedDate,6,2)) AS Expr1
FROM qryPaymentPostedDate;
is turning my date into this: 04-05-2016 00:00:00.000 instead of the mm-dd-yyyy I needed. I say "seems" because the resultset is nothing but #Error all the way to the end of the list.
Thanks for your help, pbaldy.