Report for Temp comments with no begin date

01/10/2024 5:07 pm EST

SELECT AccountNumber
FROM AccountMain
WHERE ID in
(
SELECT AccountID
FROM AccountComment
WHERE CommentType = 'T' and CommentBeginDate = '1980-01-01 00:00:00' and Comment != '')
and AccountNumber NOT LIKE '~%-%-%'

Was this article helpful?