Reply To: Querying Work Orders between two Actual Finish dates

Forums MxLoader Querying Work Orders between two Actual Finish dates Reply To: Querying Work Orders between two Actual Finish dates

#20111
Craig Kokay
Participant

I have just run your query with minor modifications.  I had to ensure that the quotes were NOT the curly type and they need to be the straight type:

 
<table border=”0″ width=”566″ cellspacing=”0″ cellpadding=”0″><colgroup><col width=”566″ /></colgroup>
<tbody>
<tr>
<td class=”xl66″ style=”height: 43.2pt; width: 425pt;” width=”566″ height=”58″><span style=”mso-spacerun: yes;”> </span>((status = ‘CLOSE’ or status = ‘COMP’) and (woclass = ‘WORKORDER’ or woclass = ‘ACTIVITY’) and istask = 0 and siteid = ‘BEDFORD’
and actfinish between { ts ‘2001-08-01 01:00:00.000’ } and { ts ‘2020-09-01 00:45:00.000’ } )</td>
</tr>
</tbody>
</table>
 

Scroll to top