I need to calculate the number of days between today's date (Now operator) and another date (DOI). I applied Treatas to the DOI and Treatas and DatePart for Now. I created a variable (FLAG - Past year) based on subracting DOI from Now to get the number of days in between. Then these are the results. You will see the NOW variable in the list table has different values. It should be the same value. The FLAG - Past year (1) is the number of days between Now and DOI. The values are incorrect. What's going wrong? Suggestions please.
... View more