Problem with stopdate-startdate

[#1]

Hi

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!

[Sokkorn]

Hi hofstedt,

Try this

[Data]:

LOAD

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

....

Regards,

Sokkorn Cheav

[jagan]

TableName:

LOAD

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

'

'

'

Hope this helps you.

Regards,

Jagan.

[#4]

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

[jagan]

Hi,

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

as a new column in your script.

or attach qlikview file.

Regards,

Jagan.