WeekDay() working in two documents but not one other

[#1]

We have a single QVW document with data only that we load in to other documents with script command:

Binary dataBinary.qvw;

In the dataBinary.qvw file we have a field:

WeekDay(RollupDate) as "Day of Week",

When looking at the "Day of Week" field in databinary.qvw it shows text "Days of Week":

Mon
Tue
Wed
Thu
Fri
Sat
Sun

In two of the documents that we load dataBinary.qvw it also shows text for "Days of Week", which is what we want.

In the third document that we load dataBinary.qvw into it show "Days of Week" as integers:

0
1
2
3
4
5
6

All three of the documents have in their scripts:

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

what could be causing the third document to be displaying "Days of Week" as integers? We want the text 🙂

[vgutkovsky]

Hmmm...that's strange. Try enclosing your original date in the date() function. If it's being seen as a num, it's possible that's the problem. So something like: weekday(date(RollupDate)) as [Day of Week]

Regards,