4 Replies Latest reply: May 8, 2012 1:17 PM by Sagar Gupta RSS

    Date/ Year/ Month... Help

      I have a Field that lists the Invoive Dates for  past sales as YYYYMMDD.  I was successfully able to convert it to MM/DD/YYYY by:

       

      Date(Date#([Invoive Date]),'YYYYMMDD'),'MM/DD/YYYY') as [Invoice Date]

       

      But, when i try to use the Year or Month Functions 01/05/2009 returns as:

       

      Month: November  Year 56904

       

      How can I correct this?

       

      Thank you!