This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I need to run a report based on 1 sql query that splits into two excel tabs. One tab for all time, next for prior 7 days, I wish to automate this using a date filter. I'm currently using a custom filter with datetimediff(datetimetoday(),[Publish_Date],"days") <= 7 but for some reason it's not giving me the right numbers. Could someone advise where I'm going wrong, or perhaps suggest a better approach?