topic Re: Why chart 1 date format display as 401218 ? in App Development

Why chart 1 date format display as 401218 ?

paulyeo11 — Sat, 20 Feb 2016 22:38:31 GMT

Hi All

I have chart 1 and chart 2 , why chart 1 unable to display the correct date format ?

Paul

Re: Why chart 1 date format display as 401218 ?

Anonymous — Sat, 20 Feb 2016 23:24:55 GMT

Hi Paul,

What about adding a date format to your existing PERIOD formula? Will it work?

Date(Pick(Match($(Var_P),1,2,3,4,5,6,7,8,9,10),(if(year>2011,year)),YearQtr,YearMonth,YearMonthWeek,YearMonthDay,REGION_,COUNTRY,GROUP_CLASS,company),'DD/MM/YYYY')

Re: Why chart 1 date format display as 401218 ?

paulyeo11 — Sun, 21 Feb 2016 03:19:18 GMT

Hi Sir

Thank you for your help.

But My Question is my below Script only work for when for Yr YrMth YrQtr .

Pick(Match($(Var_P),1,2,3,4,5,6,7,8,9,10),(if(year>2011,year)),YearQtr,YearMonth,YearMonthWeek,YearMonthDay,REGION_,COUNTRY,GROUP_CLASS,company)

But above script not work when i Click on Button YrMthDay. As it display 42418 , Can you advise me how to make it work ?

Paul

Re: Why chart 1 date format display as 401218 ?

Mon, 22 Feb 2016 09:54:33 GMT

What is source for loading your data ?

if it is SQL then int he query itself use cast date for the column...

Re: Why chart 1 date format display as 401218 ?

kaushiknsolanki — Mon, 22 Feb 2016 10:19:52 GMT

Hi,

Its because the dates are converted into julian date.

Use Date() function to show it in date format.

Pick(Match($(Var_P),1,2,3,4,5,6,7,8,9,10),(if(year>2011,year)),YearQtr,YearMonth,YearMonthWeek,Date(YearMonthDay),REGION_,COUNTRY,GROUP_CLASS,company)

Regards,

kaushik Solanki

Re: Why chart 1 date format display as 401218 ?

paulyeo11 — Mon, 22 Feb 2016 11:21:30 GMT

Hi Kaushik

it is working fine now. many thank. Any idea why add Date infront will solve the problem ?

Paul

Re: Why chart 1 date format display as 401218 ?

paulyeo11 — Mon, 22 Feb 2016 11:23:46 GMT

Hi sir

My date is from QV data.

Now it is okay

Paul

Sent from my iPhone

Re: Why chart 1 date format display as 401218 ?

kaushiknsolanki — Tue, 23 Feb 2016 19:38:51 GMT

Hi,

Because the Date function will convert the number into date. In your case it was a number which was converted into date by Date function.

Regards,

Kaushik Solanki