calculation on system date

[jalal]

Hi,


I am developing a small application for a school. In the school they teach 5 subjects in five periods. One period’s time in 40 minutes. I want to develop a table which will display the next period after previous period is over. The computer must skip to next period on the basis on system time.
Can any body help please.

jalal

[aytee111]

What is your actual calculation? Are the period's times stored somewhere? There is DateAdd or DatePart.