This content has been marked as final. Show 4 replies
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?