topic Difference between dates in QlikView

Difference between dates

Tue, 25 Oct 2011 16:15:38 GMT

Hi,

I got 2 date fields:

- "Dt End"

- "Dt Start"

Which are in the xls format:

Dt End 40820,50326

Dt Start 40820,01286

I need to create a new filed which reports the difference between this dates in terms of numbers of days.

I used this: Interval ("Dt End"-"Dt Start",'DD') as "Giorni"

But is not working properly..it gave me results formatted in days but is seems is having decimals (not expressed) so i got lots 00,01,02,03,04 but i need them as unique values

Difference between dates

Tue, 25 Oct 2011 16:33:24 GMT

networkdays will be perfect but i need to include also non-working days

Difference between dates

m_woolf — Tue, 25 Oct 2011 17:15:29 GMT

Try:

floor("Dt End")-floor("Dt Start")

Difference between dates

erichshiino — Tue, 25 Oct 2011 20:02:19 GMT

You can also try:

daystart("Dt End")-daystart("Dt Start")

Floor("Dt End"-"Dt Start",'DD')

Ceil( Interval ("Dt End"-"Dt Start",'DD'))

Round( Interval ("Dt End"-"Dt Start",'DD'))

Hope this helps,

Erich