Hi David,
What are you trying to query? Below are partial queries we're using:
1. WOTRACK: You want to find all work orders since January 1st
actfinish >= '2022-01-01 04:00:00.000'
2. PM: PMs due in the next 60 days
nextdate <= current date + 60 days
Thanks,
------------------------------
Matt McGuire
Aquitas Solutions
https://www.aquitas-solutions.com/------------------------------
Original Message:
Sent: 02-04-2022 08:13
From: David Pattengale
Subject: Date query help
I am on DB2, Sorry, should have included that!