select top 4 id, newsTitle, PublicationDate
From tblWSNews
where itemTypeId = 1 and publicationDate <=getDate() and (expiryDate >=getDate() or expiryDate is null)
and projectId in (select id from tblProjects where programmeId = #progId#)
ORDER BY tblWSNews.PublicationDate DESC;
SELECT top 4 VacancyID, tblVacancies.Title As VacancyTitle, DateOfIssue, office, Deadline
FROM tblVacancies
WHERE (((tblVacancies.DateOfIssue)<=#createodbcdate(DateFormat(now(),'mm/dd/yyyy'))#) AND ((tblVacancies.Deadline)>=#createodbcdate(DateFormat(now(),'mm/dd/yyyy'))#) AND ((tblVacancies.VacStatusID)=3) AND ((tblVacancies.VacTypeID)=1))
ORDER BY Deadline desc;
Vacancies
#VacancyTitle#
Expires on #DateFormat(Deadline,'dd mmm yyyy')#
SELECT top 4 tblVacancies.Title As RFPTitle, DateOfIssue, Deadline, VacancyID, office
FROM tblVacancies
WHERE (((tblVacancies.DateOfIssue)<=#createodbcdate(DateFormat(now(),'mm/dd/yyyy'))#) AND ((tblVacancies.Deadline)>=#createodbcdate(DateFormat(now(),'mm/dd/yyyy'))#) AND ((tblVacancies.VacStatusID)=3) AND ((tblVacancies.VacTypeID)=2))
ORDER BY DateOfIssue desc;
Current Procurement Requests
#RFPTitle#
Expires on #DateFormat(Deadline,'dd mmm yyyy')#