Date Time Programming Question

Posted on 2007-11-19
Last Modified: 2013-12-04
Ok, I am writing a program in VB.NET using Visual Studio and I need to incorporate code to make the program "aware" of what day it is. For instance, I want it to act differently (as in perform different tasks) on Monday than Tuesday etc. Also, I want it to act differently at 1:00PM than 1:00AM and so on. The program is running tasks continously and I need a way to keep a monitor running so as to check the time and "know" when to switch modes (perhaps asynch?). I am awarding 500 points not for difficulty but for speed and the numerous questions asked in one. Thank you.

pseudo code

if Monday then
do mondayProtocol

check time
if time > 1700 and <1800 then
do sixOClockRoutine

if time = 0000 then
run midnightBackup

Question by:chosen19
LVL 85

Expert Comment

by:Mike Tomlinson
Comment Utility
You have:

    if Monday then
        do mondayProtocol

and your app is "running tasks continously" does that mean your app is also running continously?

It is technically Monday at you want "mondayProtocol" to run when?

(a) At midnight on Monday
(b) Only once each Monday when the app is started
(c) Every time the app is started on Mondays
(d) Something else

What should happen if the app is not run on Monday at all?

Typically you have three choices for these types of apps:

(1) Use a Polling Timer and compare the current time against a list of events.
(2) Create a seperate thread for each event and put it to sleep until it should wake up.
(3) Use an external scheduling mechanism (such as windows scheduler) and pass an event "ID" into the app via command line arguments.

Author Comment

Comment Utility
My app is running continously and the Monday protocol would run all day Monday from 0000 until approximately 2300 when a subroutine would begin preperation for the Tuesday protocol. Also while running, the changing of the hour would change Monday subroutines.

a generic hierarchy would be

General Week Protocol (Normal Operations)
           Crossover         Crossover          Crossover    Crossover     Crossover       Crossover
Monday            Tuesday          Wednesday     Thursday         Friday             Saturday          Sunday
0000 Routine    0000 Routine   0000 Routine   0000 Routine   0000 Routine  0000 Routine    0000 Routine
0100 Routine    0100 Routine   0100 Routine   0100 Routine   0100 Routine  0100 Routine    0100 Routine

with all the hourly routine (sorry I'm an mixing the terms routine and process/procedure) incrementing hourly so that theoretically each hour of each day has a seperate routine triggered - even if the routine calls for the app to do nothing.

I like the seperate thread idea, that seems to be the most logical for my situation as it would allow my crossover routine to work in the background while the other routines are running and would allow my program to continue it's foreground work. Could you elaborate with a specific code example on constructing the thread and setting it to initiate at a specific day time?

Expert Comment

Comment Utility
Is this going to be a console app or a windows form?  If you are using a form, drop a timer control on the form.  Set its interval to 1000 milliseconds (i.e. 1 second).  Make sure that it is enabled (I say that becuase I forget that step from time to time :>).

Do some additional research on threading.  It is a very complicated issue (concurrency issues and the like)
The code I have provided I think will work, but I haven't done much threading.  

In the Timer tick event, you can use the following code

Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
dim myDate as date = now
 Select Case mydate.DayOfWeek
            Case DayOfWeek.Sunday

            Case DayOfWeek.Monday
                'monday is the subroutine to which the thread will execute
                Dim myThred As New Threading.Thread(AddressOf monday)
            Case DayOfWeek.Tuesday
            Case DayOfWeek.Wednesday
            Case DayOfWeek.Thursday
            Case DayOfWeek.Friday
            Case DayOfWeek.Saturday
        End Select
end sub
private sub monday()
 Select Case myTime
            Case Is = CDate("00:00:00")
  end select
end sub
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

LVL 39

Expert Comment

Comment Utility
The 'at' command in a command window (DOS Box) can do all the scheduling you need. Simply make a separate prog for each job and and let Windows do the scheduling.


    at /?


    help at

at the command prompt if you want to learn more.

Regards, Alex

Accepted Solution

andrewneely earned 250 total points
Comment Utility
You can also use teh scheduled tasks dialog from windows to do the same.  The only problem is that if you have many tasks set up, changing your password can be tedious.  We make batch files that update the password on every task. Here is a sample of the batch file.
@rem This program changes the password for the scheduled task to run under Windows Task Scheduler.
@rem If you add or delete tasks please change the list of tasks below.
@IF X%1==X GOTO Usage
@IF X%2==X GOTO Continue
@goto Usage

@schtasks /CHANGE /TN "Entry2Paf" /RU %USERNAME% /RP %1
@if %errorlevel%==0 goto CONT2

@schtasks /CHANGE /TN "Backup_db"          /RU %USERNAME% /RP %1
@goto done

@echo When attempting to change the first task in the batch
@echo the task scheduler returned an error (errorlevel = %errorlevel%).
@echo .
@echo The attempt to change the task to run under
@echo user %USERNAME% and password %1
@echo failed.
@echo .
@echo Skipping remaining changes
@goto done

@Echo NewPass.bat is used to change the passwords for scheduled task
@Echo .
@Echo Syntax
@Echo    NewPass NewPassWord
@Echo .
@Echo Example
@Echo    NewPass Te$t1o
LVL 85

Assisted Solution

by:Mike Tomlinson
Mike Tomlinson earned 250 total points
Comment Utility
Maybe something like this?  (with more nested Select Case statements)

Imports System.Threading

Public Class Form1

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim T As New System.Threading.Thread(AddressOf SleeperThread)

        T.IsBackground = True


    End Sub

    Private Sub SleeperThread()

        Dim dt As DateTime = DateTime.Now

        While True

            ' sleep until the top of the next hour...

            dt = DateTime.Now

            dt = New DateTime(dt.Year, dt.Month, dt.Day, dt.Hour, 0, 0).AddHours(1)


            ' do something based on the current day and time...

            Select Case DateTime.Today.DayOfWeek

                Case DayOfWeek.Sunday

                Case DayOfWeek.Monday

                Case DayOfWeek.Tuesday

                Case DayOfWeek.Wednesday

                Case DayOfWeek.Thursday

                Case DayOfWeek.Friday

                Case DayOfWeek.Saturday

                    Select Case DateTime.Now.Hour

                        Case 0

                            Debug.Print("Saturday: 0000 hrs")

                        Case 1

                            Debug.Print("Saturday: 0100 hrs")

                        ' etc...

                    End Select

            End Select

        End While

    End Sub

End Class

Open in new window


Expert Comment

Comment Utility
Forced accept.

EE Admin

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now