Subtracting dates

Anonymous — Mon, 16 Nov 2015 07:24:24 GMT

I need some help with calculating close days for cases

If the cases are still open (Case Completed Field) the Disciplinary
Interview Outcome Date = 9999-12-31.

So for open days on open cases I use this formula:

=num(Today())-num([Date of Alleged Offence])

Close days on close cases I use this formula:

=num([Disciplinary Interview Outcome Date])-num([Date of Alleged Offence])

I would like to use one formula for open and closed cases to
calculate Case Days. Could you assist with a possible solution or if
statement?

My problem is that it shows 2 917 832 days
for open cases on my close case days formula

Re: Subtracting dates

PrashantSangle — Mon, 16 Nov 2015 10:44:18 GMT

Hi,

NUM(Date#('9999-12-31','YYYY-MM-DD')) is equal to 2958465

therefore you can try like

if(num([Disciplinary Interview Outcome Date])=2958465,

num(Today())-num([Date of Alleged Offence]),

num([Disciplinary Interview Outcome Date])-num([Date of Alleged Offence])

)

Regards