To find the Same day closure status of a ticket i am comparing created date and closed date and the code is as follows:
if(num(makedate(year(Created),month(Created),day(Created)))=num(makedate(year(Closed),month(Closed),day(Closed))), 'Yes','No') as _SameDayClosure
So if a ticket is logged at 4 pm and it is closed within midnight same day closure will be yes.
In my scenario i want to find whether the ticket is closed within 24 hrs so how can i do the calculation i.e if we consider the same ticket logged at 4.00 pm ,it is closed at next day 4.00 pm and i want to make the status as yes.can anyone help?
