Keith Posted December 5, 2017 Share Posted December 5, 2017 Hi, I have had reports from a colleague that their previous dashboard is no longer working as expected. Has anything changed? For a 7 day period we previously used e.g. : h_dateresolved >= current_date-7 AND h_fk_team_name='LMS IT NA Service and Support' This does not work anymore. We now need to use : h_dateresolved >= DATE_SUB(current_date, INTERVAL 7 DAY) AND h_fk_team_name='LMS IT NA Service and Support' Regards Keith Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now