G
gatarossi
Dear all,
I'm trying to do a consult in ms access from excel, but in this
segment of SQL doesn´t work:
My problem is in: m and yyyymm, I have already put "m", 'm' but it
doesn´t work.
CStr(Format(DateAdd(m,(-[period]),CDate(Left([year_month],4) & " - " &
Mid([year_month],5,2))), yyyymm) & Mid([year_month],7)) AS Expr1
How can I solve this problem?
Thanks a lot!!!
André.
I'm trying to do a consult in ms access from excel, but in this
segment of SQL doesn´t work:
My problem is in: m and yyyymm, I have already put "m", 'm' but it
doesn´t work.
CStr(Format(DateAdd(m,(-[period]),CDate(Left([year_month],4) & " - " &
Mid([year_month],5,2))), yyyymm) & Mid([year_month],7)) AS Expr1
How can I solve this problem?
Thanks a lot!!!
André.