Query for data in the last 30 days


#1

My colleague @eugenia shared this amazing query with me to select only last 30 days data.

Modify accordingly.

SELECT ToDate(S) WHERE DATEDIFF(ToDate(Now()),ToDate(S))<30

Thanks @eugenia!