Subtract Time

[Guest]

I have a system time on my form, I want an alert to display when this time
(system time) is less than an hour (amount giving by user) away.

 

[Douglas J. Steele]

You can use DateAdd (with a negative amount) to do date and time arithmetic.

 

[David C. Holley]

Should be as simple as systemTime - formTime
Access views the numbers as Long Integers so its simple math.

 

[David C. Holley]

It should be as simple as subtracting the current system time from the
time given by the user since Access views dates/times as numbers.