Calculate number of days excluding start and end date 1

[Mr2006]

,

I want to count the days between two days and exclude the start date and end date in a report Example,

Start date 01/01/2008 and enddate 01/03/2008 the result will be 1

 

[Kiwiman]

try in your underlying query. Per your above example, this will give 1 as the result

Diff:datediff("d",yourdate1,yourdate2)-1

Take it Easy
Man with one chopstick go hungry

 

[Mr2006]

Wow...it worked perfectly. Thank you