Days calculation using Mid night

[rupali08]

Can anyone help on this?I need to create a formula in Crystal Report XI which will calculate how many days are there between the start date and end date by counting how many times mid night occured between those date range.Find example below

StartDate&time:2/18/2011 1:47:02 PM
EndDate&time:2/19/2011 6:31:00 PM
Day should be =1day (as midnight occued once)

StartDate&time:2/5/2011 12:57:27 PM
EndDate&time:2/7/2011 12:45:00 PM
Day should be =2days (as midnight occued twice)

 

[SkipVought]

Hi,

It is essentially the INTEGER part of the DIFFERENCE bweteen the two date fields.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Madawc]

DateDiff should do it automatically, something like

DateDiff ("d", {date1},  {date2})

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[rupali08]

Thanks guys for your replies.it is working like a charm!