Forum Discussion
Solved
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
Hi,
SELECT tblDocs.*, tblDraws.FundingDate
FROM tblDraws INNER JOIN tblDocs ON tblDraws.DrawNo = tblDocs.DrawNo
WHERE [FundingDate]-Date()<=3
Servus
Karl
****************
Access Bug Trackers
Access News
Access DevCon
- thank you Karl.
George, yes it is the number of days.
