How to convert my date field to Dual ?

[paulyeo11]

Hi All

I have below script :-

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

as YearMonthDay,

I get number instead of date . So i think if i change the above script to Dual , it should help.

Paul

[PrashantSangle]

Hi,

try might be it is text not number.

num#()

try like

Date(num#(fieldName))

Regards

[paulyeo11]

Hi Max

when i try your script :-

Date(num#([@50:60T]))  as YearMonthDay,

it return null .

Paul

[PrashantSangle]

Hi,

Can you post screen shot of your dashboard

Since i am working on personal edition.

Regards

[paulyeo11]

Hi Max

Do you mean this ? ( which i don't think it help you ) it only can show you it work fine in QV only.

[sasiparupudi1]

Hi

I think your date is a text

Try

Date(Date#([@50:60T],'DD/MM/YYYY'))  as YearMonthDay

hth

Sasi

[paulyeo11]

Hi Sasi

your script below :-

Date(Date#([@50:60T],'DD/MM/YYYY'))  as Yeafield,rMonthDay,

work in QV but does not work in QS.

if i plot the bar chart directly from YearMonthDay , it work fine. when i use variable it does not work , only happen on this field.

[sasiparupudi1]

what is the default date format set in your script in QS? is it DD/MM/YYYY or some thing else? please check

SET DateFormat='DD/MM/YYYY';

[paulyeo11]

Hi Sasi

I have set the date format as your suggest , still the same.