Forum Discussion
BrianCameron
Qrew Trainee
Mark,
Here is a sample of reconciled records that formula is not filtering out.
Appears that the formula is having a difficult time processing dates in these lines:
If([RiverSmart Homes]
and
(IsNull([Audit Date]) or [Audit Date] < [Date re-audit requested])
and
not [Test account]
and
[Site Owner - Public User]
and
(not [RSR auto-enroll] or [RSR Auto-Enroll Application Date] < [Date re-audit requested])
and
([Remove from waitlist]=0 or not IsNull([Date re-audit requested]))
and
(not [RSH Import] or not IsNull([Date re-audit requested])),true,false)
and
(IsNull([Audit Date]) or [Audit Date] < [Date re-audit requested])
and
not [Test account]
and
[Site Owner - Public User]
and
(not [RSR auto-enroll] or [RSR Auto-Enroll Application Date] < [Date re-audit requested])
and
([Remove from waitlist]=0 or not IsNull([Date re-audit requested]))
and
(not [RSH Import] or not IsNull([Date re-audit requested])),true,false)
BrianCameron
2 years agoQrew Trainee
Mark,
All is good. Thanks for your help!
Brian