The missing piece not mentioned in any of these answers nor any other search result I can find (though the OP hints at it) is that the date cannot be a string, it must be a string CAST AS A DATE OBJECT
set startDate to date "Sunday, April 20, 2025 at 12:00:00 AM"