Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a set of data with the date field that I am converting to month, year and day
this is the format of the date 20100301
Year(INVDATE) as Year,
Month(INVDATE) as Month,
Day(INVDATE) as Day
The Month and Day fields are working correctly as required the year field is returning 56933 and 56934
I usually use this method and cannot understand why it isnt working for the year field im assuming this is the epoc date?
Please could you advise
Try with Left,Right and Mid functions to convert
Try with Left,Right and Mid functions to convert
Thank you the left function solved my issue
Great,Pls close the conversation with answered
Hi
Try setting the format setting to date under the number tab on chart properties
regards
Padma