I am calculating the age of a store using today's date and the latest dev date. As I am also looking up dev dates for future too, my age is also being calculated as negative. In the following formula fow do I restrict the result to count latest dev date on or before today?
var date LDD = [Latest Dev Date];
var date PolicyDate = Today();
Year($PolicyDate) - Year($LDD)
-
If(
Month($PolicyDate) < Month($LDD)
or
(Month($PolicyDate) = Month($LDD) and Day($PolicyDate) < Day($LDD)),1,0)