I ended up using the NetRemoteTOD function
________________________________
From: Jose Gomez <jose@...>
To: vantage@yahoogroups.com
Sent: Friday, September 23, 2011 10:12 AM
Subject: Re: [Vantage] Reset DB field
you can install NTP Serer on that server and then query it using WMI
*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>Â <http://www.facebook.com/josegomez>
 <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
 <http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
 <http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
________________________________
From: Jose Gomez <jose@...>
To: vantage@yahoogroups.com
Sent: Friday, September 23, 2011 10:12 AM
Subject: Re: [Vantage] Reset DB field
you can install NTP Serer on that server and then query it using WMI
*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>Â <http://www.facebook.com/josegomez>
 <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
 <http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
 <http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
On Fri, Sep 23, 2011 at 9:59 AM, Ted Koch <tkoch77@...> wrote:
> **
>
>
> Is there a way to retrieve the time from the server running my database?
>
> ________________________________
> From: Jose Gomez <jose@...>
> To: vantage@yahoogroups.com
> Sent: Friday, September 23, 2011 9:00 AM
> Subject: Re: [Vantage] Reset DB field
>
>
> Use a web based time server?
> http://developer.yahoo.com/util/timeservice/V1/getTime.html
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
>
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>Â <
> http://www.facebook.com/josegomez>
>Â <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
>Â <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>Â <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Fri, Sep 23, 2011 at 8:16 AM, tkoch77 <tkoch77@...> wrote:
>
> > **
> >
> >
> > I am currently auto generating project IDs with a format of 11-A-0000. 11
> > will be the year, A relates to a company (will also have B,C,etc.), 0000
> is
> > a sequential number. When it turns 2012, I want the sequential number to
> be
> > reset to zero. Currently I am using the users system time to run a check
> on
> > the year so it will reset the sequential number. I don't think this is
> the
> > best way to go about this because if for some reason a users computer
> clock
> > were to get changed, not sure why it would but stuff happens, it would
> screw
> > up the ID creation process. Anyone have any other recommendations on how
> to
> > check when a new year arrives and reset a DB field?
> >
> > Thanks,
> > Ted
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
> [Non-text portions of this message have been removed]
>
>Â
>
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]