Hi, I have a Continuous form where I am trying to add a calculated feild that allows us to see how many days a client was in hospital. There is a start and end date. I want to see the following: If start date and end date are the same, this should show client in hospital for 1 day, not the default of 0. If start date 5/1/13 and end date is 5/3/13 it should show 3 days in hospital. If start date is 5/1/13 and there is no end date, this should show 7 dates (from start date to today's date or current date). Currently I have =DateDiff("d",[EStartDate],[EEndDate])-([EStartDate]=[EEndDate]) but it only shows 1 if the start date and end date is the same. I need it to include the start and end dates typed in its equation. I hope that makes sense and someone can help with the answer.
Thanks