Re: scheduler

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: lofepramine (depression-sucks_at_deep.org)
Date: 11/27/04 

Date: Sat, 27 Nov 2004 14:51:47 -0000

i think i have the answer now anyway

Dim FirstDate As Date ' Declare variables.
Dim IntervalType As String
Dim Number As Integer
Dim Msg
IntervalType = "m" ' "m" specifies months as interval.
FirstDate = InputBox("Enter a date")
Number = InputBox("Enter number of months to add")
Msg = "New date: " & DateAdd(IntervalType, Number, FirstDate)
MsgBox Msg

"lofepramine" <depression-sucks@deep.org> wrote in message
news:u1dbsaH1EHA.1740@TK2MSFTNGP15.phx.gbl...
> i am sorry for the mistake.
>
> here is better explanation
>
> we have to maintain a large database on a regular basis
> but because we don't have a regular person to do the
> updating, we need to create some kind of reminder.
> like a list box filled with the sections that need updating
> this month.
>
> once any section has been updated, i need to calculate
> the date in 6 months time, so that section can be updated again
>
> the database has 26 individual sections that need to be
> updated every six months.
>
> so what i essentially need to be able to do is
> get todays date tDate = FormatDateTime(Date, 2)
> then calculate what the date will
> be in six months time. when i have that date, i'll store it
> in either an INI file or in the registry, when the program
> is started every morning, the program will read each Date
> and determine which record needs to be updated.
>
> if a date needs to be updated, the section name will be
> added to a listbox
>
>
> thanks for any help
>
> "Jeff Johnson [MVP: VB]" <i.get@enough.spam> wrote in message
> news:%23iaizZE1EHA.3108@TK2MSFTNGP12.phx.gbl...
> >
> > "lofepramine" <depression-sucks@deep.org> wrote in message
> > news:u6kR8V$0EHA.1308@TK2MSFTNGP09.phx.gbl...
> >
> > > i need to create an application that calculates a date
> > > in six months time, then lists some database entries
> > > that would need to be updated.
> > >
> > > could someone point me to a usefull URL please
> >
> > I doubt anyone can help you given the vague requirements you have set
> forth.
> > Please be more specific.
> >
> >
>
>

Relevant Pages