Data Conversion with DatePart in an MS access select query -

Data Conversion with DatePart in an MS access select query -

i trying utilize datepart() within ms access select query extract month , year-- number-- date in string form of

"yyyy-mm-dd hh:nn:ss.0000000"

the initial code written else says:

datepart("m", date) datepart("yyyy", date)

but causing "data type, mismatch in criteria" error when query ran, attempted utilize cdate() convert string date type.

datepart("m", cdate(date)) datepart("yyyy", cdate(date))

however did not solve problem. wondering if initial date string not in form cdate() can convert, or if there easier way extract partial, numerical date date string such mine.

i prepared elaborate much farther on situation in case question incomplete, did not wish ahead of myself.

those zeros problem, strip them, say

cdate(mid(sdate, 1, instr(sdate, ".") - 1))

then

datepart("m", cdate(mid(sdate, 1, instr(sdate, ".") - 1)))

however, may find more convenient refer appropriate part of string:

ayr = left(sdate,4) amnth = mid(sdate,6,2)

select ms-access-2007 insert-into