I am trying to set up a "time elapsed" field in my report. I want the report to calculate the number of days passed from the initial contact date, to the closing date, which I have in respective fields. However, if the closing date is null, I want the time elapsed from initial contact date to TODAY's date calculated.
So far I have =DateDiff("d",[Initial Contact],Date()) for when the date closed field is null.. and ,=DateDiff("d",[Initial Contact],[Date Closed]) to calculate from initial date to closed date. But I'm not sure how to merge these two into a single code.. any suggestions??
Thanks!