I've been trying to load and sort a tmp table and create variable names out of dates. It seems to mostly work, however it is not properly sorting the dates in descending order. Below is my load script and the resulting table. Thanks for any help.
Month(WEEK_START) as Start_Month,
Week(WEEK_START) as Start_Week,
Day(WEEK_START) as Start_Day,
Month(WEEK_END) as End_Month,
Week(WEEK_END) as End_Week,
Day(WEEK_END) as End_Day,
Year(WEEK_END) as End_Year,
MINUTES as Inbound,
MINUTES as Outbound,
(MINUTES *2) as [Total Minutes]
(ooxml, embedded labels, table is Sheet1);
NoConcatenate load DISTINCT WEEK_START AS StartDT, WEEK_END as EndDT
Also you may try playing with data types, i.e. Dual() or Num() functions in order to convert initial value into a numeric one. I just cannot see what you source data and local settings are, on the other hand QV have to parse dates and process them properly.