5 Replies Latest reply: Dec 22, 2015 4:46 PM by Spam Hackback RSS

    MS Access load datetime field as YYYYMM

      Hi Experts,


      This is probably a silly question, but what is the syntax to load an MS Access DateTime as YYYYMM?  I tried this, but it's not working


      Date(Date#(VisitDate, 'YYYYMMDD'), 'YYYYMM') as 'VisitYear Month',


      Thanks in advance!