Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Can you post the expression you are using?
Year(Date#([Invoive Date]),'YYYYMMDD')) as [Invoice Year]
should work.
Year(MakeDate(Left(DATE,4),Mid(DATE,5,2),Mid(DATE,7,2))) as [Year],
Month(MakeDate(Left(DATE,4),Mid(DATE,5,2),Mid(DATE,7,2))) as [Month],
Day(MakeDate(Left(DATE,4),Mid(DATE,5,2),Mid(DATE,7,2))) as [Day],
I have helped
Can you post the expression you are using?
Year(Date#([Invoive Date]),'YYYYMMDD')) as [Invoice Year]
should work.
Rob: That worked! THANK YOU!
I need your help Mr Rob, will U?
Regards
Sagar Gupta