HI Aaron, I think I got it. I may need to deal with the timestamp, but seems to be working.. Thanks.. select wonum, reportdate from workorder where reportdate > dateadd(day, -datepart(weekday, getdate()), getdate()) - 6 and reportdate < dateadd(day, -datepart(weekday, getdate()), getdate...
Hi Brian - I think I found a similar request to the challenge you have described. I would recommend you use the dateadd function combined with the datepart function, to define the "Starting Date" of the prior week. You can then add 7 days to the "Starting Date", to give you your "Ending Date"....
HI all, In SQL Server, I'm attempting to create a query that will select all workorders based on the reportdate generated the previous week, no matter what day of the current week I'm in. I did this for a monthly view, but struggling with the weekly range. I have looked at the datepart...
#Administration #Analytics #Reporting #EverythingMaximo
Links referenced in the video.pdf
Business needs to make decisions for maintenance, repair and operations (MRO) using data. Your individual organization has a chart of accounts already in place, but the MRO activities tend to be aggregated into a small number of accounts. Maximo enables you to be more specific on what charges go...
Join CommunityInvite ColleaguesLearn More
About UsTerms of Use