Querying Work Orders between two Actual Finish dates

[Hannah Grace-Parker]

Hi,

I have been trying to query work orders between August 1st and 31st, and I have used the advanced search in Maximo to copy the ‘where clause’ into the query cell for MxLoader (I am not a coding genius!), however, this code does not want to run in MxLoader and I figure it is something to do with the way the timestamp is put in, but I have no idea what to do to change it.

Here is the where clause code I am using:

((status = ‘CLOSE’ or status = ‘COMP’) and (woclass = ‘WORKORDER’ or woclass = ‘ACTIVITY’) and actfinish <= { ts ‘2020-09-01 00:45:00.000’ } and istask = 0 and siteid = ‘DUB’ and actfinish >= { ts ‘2020-08-01 01:00:00.000’ })

Many thanks,

Hannah

[Hannah Grace-Parker]

Still looking for a solution to this problem if anyone has any ideas?

[Author]

Posts