RE: Compare two timestamps from MS access DB

Tech-Archive recommends: Speed Up your PC by fixing your registry

timespan will allow me to complete this. thank you for everyone who spent
time on this. -dale

"dale zhang" wrote:

> let's make this more clear.
>
> Can we convert timestamp to an int for further calculation?
>
> Thanks. -Dale
>
> "dale zhang" wrote:
>
> > Hi,
> >
> > I have a MS access DB with some users signed in at different dates.
> >
> > I want to check the DB daily to compare everyone’s timestamp against current
> > date to find who’s in our DB for more than two weeks. How could I do this?
> >
> > Can I run a thread every day (let’s say 8pm) in C# to read everyone’s time
> > and compare it against current time (how to do?)?
> >
> > Or write a script run against ms access manually or automatically?
> >
> > Any suggestions?
> >
> > Thanks. -Dale
> >
.

Relevant Pages

  • RE: Compare two timestamps from MS access DB
    ... Can we convert timestamp to an int for further calculation? ... "dale zhang" wrote: ... > and compare it against current time? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SQL Server via MS Access
    ... > I am able to modify some of the records in Access, ... You need to add a TIMESTAMP column to each SQL table, ... this, by default, it codes the update to compare every field. ... Access can simply check using the TIMESTAMP column. ...
    (microsoft.public.windows.server.sbs)
  • Re: HELP! compare two SQL timestamps in C# byte arrays
    ... The inherent 'timestamp' for a record isn't based on time and as such to compare as being larger / ... The problem is I am not testing for Equality. ... >> how do convert\manipulate the arrays to something I can compare. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: History of bulk electronic components suppliers
    ... has spent on fighting poverty since 1960 with well-intentioned ... Compare it to how much the US has spent on pointless or losing wars. ...
    (sci.electronics.design)
  • Re: comparing PE files with CRC/checksum
    ... >>My application requires the ability to compare two files using a CRC32 ... If two object files differ only in their timestamp they are ... digital fingerprint without ever modifying the binary file. ... But the bottom line is that I consider two object files identical ...
    (microsoft.public.win32.programmer.kernel)