2 Replies Latest reply: Aug 2, 2013 6:25 AM by Zama Phumla RSS

    Date Converting

      Hello people

       

      I have month and date in 2 separate columns on a spread sheet but want a MonthName (Jan 2013)

       

      I have already converted month into a proper date (Month(Date#((Left(Month,3)),'MMM')) as Month,) and year (Year(Date#(Year,'YYYY')) as Year,)

       

       

      Now how can I combine the 2 to from a MonthName?

       

      Thanx