I have a processing screen that pulls records based on a date range.
public PXFilteredProcessing<AuditHistory, QTCAuditHistoryReportFilter,
Where<AuditHistory.screenID.IsEqual<QTCAuditHistoryReportFilter.screenID.FromCurrent>.
And<AuditHistory.changeDate.IsBetween<QTCAuditHistoryReportFilter.startDate.FromCurrent, QTCAuditHistoryReportFilter.endDate.FromCurrent>>>> RecordsToProcess;
The filter screen looks like this.
The problem is that if there is a record in the AuditHistory table with a change date of
2022-07-06 21:44:08.583 it won’t get selected. I need my selector to just look for the DATE portion and ignore the time portion.
Is there something I can do in my selector to just use the Date portion?
Best answer by Naveen Boga
View original