topic Problem with stopdate-startdate in QlikView

Problem with stopdate-startdate

Tue, 13 Dec 2011 08:51:26 GMT

I have a start and a stopdate, my goal is to get the number of days between these. I work find when it´s in the same month but anything else get wierd. The date is in form of yearmonthday.

Thanks!

Problem with stopdate-startdate

Sokkorn — Tue, 13 Dec 2011 08:54:16 GMT

Hi hofstedt,

Try this

[Data]:

LOAD

DATE(EndDate) - DATE(StartDate) AS [NoDay],

....

Regards,

Sokkorn Cheav

Problem with stopdate-startdate

jagan — Tue, 13 Dec 2011 10:32:21 GMT

TableName:

LOAD

Date#(EndDate, 'YYYYMMDD') - Date#(StartDate, 'YYYYMMDD') AS DaysDiff

Hope this helps you.

Regards,

Jagan.

Problem with stopdate-startdate

Tue, 13 Dec 2011 14:05:43 GMT

Sorry, I´m a newbe. Were do I put this? Would really be greatful for a exampel...

Problem with stopdate-startdate

jagan — Tue, 13 Dec 2011 14:11:06 GMT

Hi,

Add this Date#(EndDate, 'YYYYMMDD') - Date#(StartDate, 'YYYYMMDD') AS DaysDiff

as a new column in your script.

or attach qlikview file.

Regards,

Jagan.