SELECT * FROM `Procurement` WHERE `PStatus` = 3 and PDeadline >= '2025-11-1' and PdatePosted <= '2025-11-1'

Procurement Title		Submission Deadline