MS Access Date Format - Microsoft Community


i writing query in ms access against table date formatted "2014-04-08 11:39:32.122876", , use criteria, between 1/1/2016 , 12/31/2016, giving me syntax error.

in past used built in function resolve issue, can't remember how work.

any appreciated.

first data date/time datatype? if so, may able add column database:

mydate: datevalue([datefield])

then set criteria column.



Office / Access / Other/unknown / Office 2013



Comments

Post a Comment

Popular posts from this blog

Windows 10 does not have any of my previous Windows 7 email address. - Microsoft Community

in windows 10, go edge , type in hotmail.com , windows 7 information including 30 address there. windows 10 email not have these addresses can not forward new emails previous list of email address wish forward to. ***post moved moderator appropriate forum category.*** hi, in regards concern, when sign account access product, create record of sign in. if sign third-party service microsoft account, asked consent share account data required service. if want remove or delete collected data or stored microsoft edge, please follow steps below: in microsoft edge, go more and click on settings . under clear browsing data , select choose clear . check boxes next data type you’d clear, select clear . if you’d like, turn on setting below check boxes always clear when close browser . here's additional information microsoft edge, browsing data, , privacy . hope above information he
Read more