If condition for latest timestamp gives an output of 1 although the latest date are not equal

[Rian0126]

Hi,

I'm not sure if there is some bug. I'm getting a value of 1 (condition is TRUE) if "Max ETL Date" is equal to "Today CREATE_TIMESTAMP".

Although when I check the breakdown for latest "Max ETL Date" and latest "Today CREATE_TIMESTAMP", the values are different. Here are the screenshots:

1. Max ETL Date

2. Today CREATE_TMESTAMP

When I created the condition that if those two latest dates are equal, it should be 1 if not 0 under "Today 2" variable name: 

"Today 2" variable is getting 1 row where "Max ETL Date" and "Today CREATE_TIMESTAMP" are equal. How come there is an instance of equal date if the dates I checked in item #s 1 and 2 above have different values?

Thank you.

x

[acordes · Accepted solution]

I think your today 2 variable needs a different aggregation.

[Rian0126]

I see. Thank you @acordes . I also used this method: https://communities.sas.com/t5/SAS-Communities-Library/Use-the-latest-date-in-your-VA-report/ta-p/53....