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?
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.