I have the following formula entered in a text box on a report
=DateDiff("d",[StartDate],[EndDate])
however if there is no EndDate then i need it to calculate the StartDate (N.B. there will always be a StartDate) from todays date in the same text box.
Can anyone please help!!!
thanks