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!