Needs database changes at precise time when campaign begins/ends
Revisions and Commits
Actually I think the implementation path to take here is to validate if a campaign is open/closed based on comparing the wall clock time to the dates in the database rather than having dates that don't mean anything and a boolean status flag. The Scholarships app could be looked at for inspiration as the application form changes state in a similar way (coming soon, active, applications closed).
@Nehajha: I am resetting the assignee of this task because there has not been progress lately (please correct me if I am wrong!). Resetting the assignee avoids the impression that somebody is already working on this task. It also allows others to potentially work towards fixing this task. Please claim this task again when you plan to work on it (via Add Action... → Assign / Claim in the dropdown menu) - it would be welcome. Thanks for your understanding!