Z
ZTamsen
I am building a query using the dateserial function to identify store open
dates that are currently stored in an integer YYYYMMDD format. I can convert
that to a date using DateSerial(left(4),Mid(5,2),Right(2)). Next I add
criteria to the query of >=date()-365 to get those stores opened within the
last year. Adding this last step causes a data type mismatch error. Any
ideas what I can do to solve the problem?
With gratitude,
zt
dates that are currently stored in an integer YYYYMMDD format. I can convert
that to a date using DateSerial(left(4),Mid(5,2),Right(2)). Next I add
criteria to the query of >=date()-365 to get those stores opened within the
last year. Adding this last step causes a data type mismatch error. Any
ideas what I can do to solve the problem?
With gratitude,
zt