Compare two timestamps from MS access DB

[dale zhang]

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

[dale zhang]

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

[dale zhang]

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