count total days

[hlkelly]

The DateDiff function works great: CalcShowDays: (DateDiff("d",[start date],[end date])

Except I want to know how many total days the show spanned. This calculates the difference but I need to include the first date. If the dates were the same (only one show day), it returns a zero.

Any help appreciated. Thank you.

 

[traingamer]

Then add one to the result:

CalcShowDays: (DateDiff("d",[start date],[end date]) [blue][b]+ 1[/b][/blue]

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[PHV]

Another way:
CalcShowDays: 1+[end date]-[start date]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886