Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a date filed with date in myy format.
For Ex: date field called Monthend has the value 113,213,313,413......
How can I covert this into jan 2013,feb 2013,Mar 2013,Apr 2013..... format ?
Thanks.
or maybe
=date(date#(num(Monthend,'0000'),'MMYY'),'MMM YYYY')
Hi,
You should load de data as follows :
Results:
LOAD MakeDate(2000+ Monthend - ( floor(Monthend/100)*100) , floor(Monthend/100) ) as date_result
FROM
and when you displays those you have to set the Format Pattern as 'MMM/YYYY' in the Number-tab.
PS: Is you are using dates from previous century, you should correct the formula.
PS2 : The solution by swuel is also working, and shorter , but I was preparing my answer when he replied.
Paul
Awesome.Thank you.