topic Re: How to calculate date difference from current system date time, that is greater than one day in App Development

How to calculate date difference from current system date time, that is greater than one day

abc_18 — Sat, 16 Nov 2024 01:58:21 GMT

Hi,

I have a date field called 'Complain_datetime'.

Requirement is to get the count of complaint ID's, for which date difference with respect to current system date is greater thn 1 day.

How to achieve this, please suggest.

Regards

Re: How to calculate date difference from current system date time, that is greater than one day

Kushal_Chawda — Mon, 06 Jul 2020 14:05:11 GMT

Would you be able to share sample data ?

Meanwhile you can try below expression

=Count({<[complaint ID]={"=today()-Complain_datetime>1"}>}ID)

Re: How to calculate date difference from current system date time, that is greater than one day

abc_18 — Tue, 07 Jul 2020 07:54:31 GMT

Hi Kush,

Thanks for your response, below expression suggested by you is working fine.

How to calculate the value in hours, I have some sla_time for each of the complains, and I have to calculate, if the time taken to resolve the complains in comparison with current date time is greater then sla_time.

Below is the expression I am using which gives me blank value.

Here Complain_datetime consist value like :- '01-04-2020 06:27:45' (changed the format in script itself)

if(round(avg(Interval(Now()-Complain_datetime,'hh')))>sla_time,count(comp_id))

Please suggest