Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have chart 1 and chart 2 , why chart 1 unable to display the correct date format ?
Paul
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
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')
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)
Paul
What is source for loading your data ?
if it is SQL then int he query itself use cast date for the column...
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
Hi Kaushik
it is working fine now. many thank. Any idea why add Date infront will solve the problem ?
Paul
Hi sir
My date is from QV data.
Now it is okay
Paul
Sent from my iPhone
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