Elapsed days up to today

[CJDK]

Going round in circles trying to create a measure that subtracts a static date from today's date (dynamic) to give a running count of elapsed days. I would have thought this very simple, but too complex for me!

It seems

ElapsedDays = DATEDIFF((DATE(2020,02,15)),TODAY(), DAY) 

and

ElapsedDays = TODAY()-DATE(2020,02,15) 

don't work

[CJDK]

Thanks Amitchandak - exactly what I needed 👍

[amitchandak · Accepted solution]

@CJDK , This formula seems correct

ElapsedDays = DATEDIFF(DATE(2020,02,15),TODAY(), DAY)

what is the problem you are facing on this, When I checked it gives a number 478 , which seem fine