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!