Time calculation

[ckleung]

My database has a field [Time], e.g. [09:30:00] , I want to add a field in the query [ArriveTime] that show the time 30 minutes earlier than the [Time], how the formular set?

 

[pr2-eugin]

Hello ckleung, lookup on DateAdd function.. Something along the lines of..

Arrivetime: DateAdd("n", [COLOR=Red][B]-30[/B][/COLOR], [actualTime])

I would strongly advice you to change your field name from Time to something different; as Time is a reserved Keyword in Access.. If the field name is just for an example ignore the above statement..

 

[ckleung]

Hi, Eugin, Thanks a lot.