MS ACCESS text date field compared with datereltoday in query
Posted on 2013-11-14
I have a field SVC_DATE stored as text in this format 20131114
and what I want to do is use a criteria of 'this month' as in current month based on todays date.
I am able to get the month out of the thing with this
SVC_MONTH: Month(Format(Mid([SVC_DATE],5,2) & "/" & Mid([SVC_DATE],7,2) & "/" & Left([SVC_DATE],4),"mm/dd/yyyy"))
And I'm having trouble with setting up the criteria of 'this month'.
I was thinking something like "Like Month(DATERELTODAY(0))" but get a data type mismatch