Please help with converting the date format.

[#1]

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.

[swuehl · Accepted solution]

or maybe

=date(date#(num(Monthend,'0000'),'MMYY'),'MMM YYYY')

[Anonymous]

Hi,

You should load de data as follows :

Results:

LOAD MakeDate(2000+ Monthend - ( floor(Monthend/100)*100) , floor(Monthend/100)  )  as date_result

FROM  (biff, embedded labels, table is Blad1$);

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

[#4]

Awesome.Thank you.