help with calculation for legnth of event

[EZ]

Hi Folks,

I created a calculation that tells me the legnth of an event. For a single day event, it results in zero and for a two day event, it results in a one.

Here's the calcualation:

Case ( End Date - Start Date = 1; End Date - Start Date & " Day"; End Date - Start Date & " Days")

How do I make it more accurate?

[mr_vodka]

Try:

Let ( d = End Date - Start Date;

Case ( not ( Start Date> End Date); d + 1 & " Day" & Case ( d; "s") )

)

P.S. I have moved your topic to calcs rather than scriptmaker

Edited July 30, 2007 by Guest
alerted of topic move