=If((datetime>=Date(Today()-7)) and (datetime <= Date(Today())), datetime)
datetime is loaded as
timestamp((timestamp/86400 + 25569 + 8/24),'DD/MM/YYYY h:mm:ss[.fff] TT') as datetime,
I have a timestamp column as below. I thought the above expression was ok but later I found out that it did not show the data after 26/12/2018 1200am. If I remove the expression and replace it with just datetime, I can see the data after 12am.