How to change my YearMonth script start to Dual ?

[paulyeo11]

Hi All

I have a Load Script as below :-

Date(Monthstart([TempDate]), 'YY MMM')

as YearMonth,

I like to change the above using Dual , meaning some thing like :-

Dual(Date(Monthstart([TempDate]), 'YY MMM'))

as YearMonth,

As i encounter issue when i use YearMonth field in QS . it display as number instead of YearMonth like 2015 Jan.

Paul

[maxgro · Accepted solution]

Dual(Date(Monthstart([TempDate]), 'YY MMM'), TempDate) as YearMonth

or

Dual(Date(Monthstart([TempDate]), 'YY MMM'), MonthStart(TempDate)) as YearMonth

[paulyeo11]

Hi Massimo

Thank you after using Dual , My chart look better in QS.

Before that it look like this , i don't like.