CA Service Management

hi everyone

Currently, I am working with a report in CABI 4.1, but my client needs to Add the days in which a ticket is open,

I added the following formula with Open Date and Resolve Date

=DaysBetween([Open Date];[Resolve Date])

but, the result is not right. some of the results show me as "0"

Can you help me to complete my formula?
I will be very grateful

I tried with the following formulas, but the result its the same

=(Si(FormatoFecha([Resolve Date]; "dd-MM-yyyy") <> "") Then ((DíasEntre([Open Date];[Resolve Date])*24*60)+((EnNúmero(FormatoFecha([Resolve Date];"HH"))*60)-(EnNúmero(FormatoFecha([Open Date];"HH"))*60))+((EnNúmero(FormatoFecha([Resolve Date];"mm"))-(EnNúmero(FormatoFecha([Open Date];"mm")))))+((EnNúmero(FormatoFecha([Resolve Date];"ss"))/60)-((EnNúmero(FormatoFecha([Open Date];"ss")))/60)))/60 Else 0)/24

*************************************

=(If(FormatDate([Resolve Date]; "dd-MM-yyyy") <>"") Then Abs((((DaysBetween([Resolve Date];[Open Date])*1440)+((ToNumber(FormatDate([Resolve Date];"HH"))*60)-(ToNumber(FormatDate([Open Date];"HH"))*60))+((ToNumber(FormatDate([Resolve Date];"mm"))-(ToNumber(FormatDate([Openate];"mm")))))+((ToNumber(FormatDate([Resolve Date];"ss"))/60)-((ToNumber(FormatDate([Open Date];"ss"))/60))))/60)) Else -1)

Hi Marco,

DaysBetween([Open Date]; [Resolve Date]) is the correct formula, however looking at your screenshot, the year and time format does not match between open date and resolve date.

Perhaps this is causing the issue?

Thanks,

Scott