Forum Discussion
Date Filter
Experts, how would I display records only if the count between current date and [FundingDate] is <=3? So, if today was 1/23/23 and the [FundingDate] was 1/27 then I wouldnt show it since it the day ...
Hi,
SELECT tblDocs.*, tblDraws.FundingDate
FROM tblDraws INNER JOIN tblDocs ON tblDraws.DrawNo = tblDocs.DrawNoWHERE [FundingDate]-Date()<=3
Servus
Karl
****************
Access Bug Trackers
Access News
Access DevCon
When you say "Day Count" is it correct to assume that you mean "Number of Days", not count of something else by day?
