Constructing a Calendar Query

Updated: Jun 21, 2021

If you are working with Maximo you must have realized the importance of calendars for numerous reasons. If you were challenged to analyze Work Orders, resources allocation, leveling or long term planning you will probably need a calendar “data set”. The following query helps constructing a dynamic calendar starting from SYSDATE plus 12 months.

Want to read more?

Subscribe to www.adijaradat.com to keep reading this exclusive post.

Subscribe Now
27 views0 comments

Recent Posts

See All

Where clauses are used in Maximo intensively, such as in relationships and search, with a few tricks where clauses can do more than just sea

There are many way to implement Google-like search facility for any system such as Maximo. This is a powerful query to search all tables and