Difference between dates

[#1]

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

[#2]

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

[m_woolf]

Try:

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

[erichshiino · Accepted solution]

You can also try:

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

or

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

or

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

or

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

Hope this helps,

Erich