topic Re: Incorrect date presentation in QlikView

Incorrect date presentation

vchuprina — Thu, 26 Mar 2015 12:16:14 GMT

I use following code to load date from file:

LET vDateRAW = subfield (peek('SOURCE_DATE', 0, 'Temp'), ' ', -1);

LET vDateDay = num(subfield (subfield (peek('SOURCE_DATE', 0, 'Temp'), ' ', -1), '/', 2), 00);

LET vDateMonth = num (subfield (subfield (peek('SOURCE_DATE', 0, 'Temp'), ' ', -1), '/', 1), 00);

LET vDateYear = num (subfield (subfield (peek('SOURCE_DATE', 0, 'Temp'), ' ', -1), '/', 3), 0000);

LET vWEEK =$(vDateYear) & $(vDateMonth) & $(vDateDay);

$(vWEEK) AS WEEK_ENDING_DATE

When I add WeekStart Function

WeekStart($(vWEEK)) AS WEEK_ENDING_DATE,

Date column start looking incorrect :

05/24/57069

What should I do to load week start date in correct format (example '20150207')?

MK_QSL — Thu, 26 Mar 2015 12:18:06 GMT

What is your SOURCE_DATE format?

vchuprina — Thu, 26 Mar 2015 12:21:59 GMT

Data as of: 2/9/2015

leandro_gocosta — Thu, 26 Mar 2015 12:26:54 GMT

Which database you use to make the extractions?

I'm asking because my settlement date format masks in sql.

rubenmarin — Thu, 26 Mar 2015 12:31:18 GMT

Hi, this can work:

Temp:

LOAD * Inline [

SOURCE_DATE

2/9/2015

];

LET vDate = Date(Date#(peek('SOURCE_DATE', 0, 'Temp'), 'MM/DD/YYYY'), 'YYYYMMDD');