katy_palmer Posted July 9, 2024 Posted July 9, 2024 I am using the advanced analytics and producing some widgets, however the variables to use are different than in the reporting. My widget shows last week but I am using h_datelogged > (now() - interval 1 WEEK) which gives me a rolling week and want it to display the last week but with the week end day as Sunday. In supportworks this would be DATE:endoflastweeksun Can someone help with what the available time periods are? This does not help - https://wiki.hornbill.com/index.php?title=SQL_Reference:_Date_Time_Functions
Victor Posted July 10, 2024 Posted July 10, 2024 @katy_palmer try this: h_datelogged BETWEEN SUBDATE(CURDATE(), WEEKDAY(CURDATE()) + 7) AND SUBDATE(CURDATE(), WEEKDAY(CURDATE()) + 1)
katy_palmer Posted July 10, 2024 Author Posted July 10, 2024 Thanks @Victor, just to confirm this will do the same as DATE:endoflastweeksun - correct?
Victor Posted July 10, 2024 Posted July 10, 2024 17 minutes ago, katy_palmer said: this will do the same as DATE:endoflastweeksun - correct? I have no idea what this "DATE:endoflastweeksun" does. My above filter will return all requests that have been raised in the previous Mon - Sun week from the date the report is run. So if it was run a query today, using the filter, it will bring back requests raised between 01/07/2024 and 07/07/2024. 1
katy_palmer Posted July 10, 2024 Author Posted July 10, 2024 That's amazing, thank you so much, should this be considered as an enhancement? (the fact that the time periods are not the same throughout the system)
Steve Giller Posted July 10, 2024 Posted July 10, 2024 1 hour ago, katy_palmer said: the fact that the time periods are not the same throughout the system We wouldn't raise an enhancement in Hornbill because it differs from Supportworks. They are completely separate products.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now