Search

directory_1.jpg
1 to 7 of 7
Sort by

Discussion Reply
RE: Select workorders generated from previous week

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...


Discussion Reply
RE: Select workorders generated from previous week

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"....



Discussion Post
Select workorders generated from previous week

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...




Discussion Post
Maximo Chart of Accounts and why you should be using it now

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...

Links referenced in the video.pdf