Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
EMP_RELIEVE_DATE
--------------------------
13/07/2020
24/07/2020
07/08/2020
=count(DISTINCT if((Date(EMP_RELIEVE_DATE,'DD/MM/YYYY') - Today() and Date(EMP_RELIEVE_DATE,'DD/MM/YYYY') - Today() > 20) ),EMP_RELIEVE_DATE))
i am getting count people who are relieving from today and past more than 30 days
I have 3 records in that count. but, I am getting "zero" count
what is the problem in the expressions.
=count(DISTINCT if((Date(EMP_RELIEVE_DATE,'DD/MM/YYYY') - Today() and Date(EMP_RELIEVE_DATE,'DD/MM/YYYY') - Today() > 30) ),EMP_RELIEVE_DATE))
can anyone check the file and give us the correct count..this is urgent and i am waiting..
Hi @saivina2920
Kush already replied to this one..
Hope it helps you