Skip to Content
0
Former Member
May 10, 2018 at 06:40 AM

calculated fields to use to as a dynamic filter

71 Views

I am trying to minus today's date with the term date to get no of days in term so that I can use the calculated fled as dynamic filter however the calculation is not giving the correct no of days

Example TODAY(in days)- Term Date( in days)

05/10/2018-04/30/2018 should be 10 days however the calculation is something different