I'm creating a SharePoint 2010 application called HR Learning And Development. Basically it's an application to manage every employee trainings. Much like a college environment. I have a SharePoint Lists named Training and Training Session. One training can have multiple sessions. The Training Session lists have Trainer, Start-date and Status column among other things. Employee who wants to enroll into this training would have to subscribe it.
The Training Session list should behave as follows :
- Status = New -> when a training session is just created
- Status = In Progress -> when the Start-date > DateTime.Now
- Status = Completed -> when the End-date <= DateTime.Now
Could you guys help me on how to solve this things.
Your help is very much appreciated. Thanks