Date time comparison with NOW() function
Hello Everyone, I have an issue with comparing two datetime values. The goal is to mark all the rows of data that are within 6:00:00 AM 3 days ago and 6:00:00 AM today: As you may see upper expression returns NO for datetime that is within last 3 days and i do not understand why is that. Two clues: 1. When i am doing IF statement only for IF CurrentRowDate>=Is3Day it returns only datetime rows for past year. Condistion is not meet for current year. 2. Previously report was build for periods midnight to midnight, i wasn't including time part - it worked. Can someone please explain what is goind on? DateTime column is Date/Time format but maybe it is still the case of different formatting used in expression?
