Solved Beginner question Second Time (1 Viewer)

[wanzi]

I want to increase the seconds display of a DateTime field by 30 seconds. I dont get any further. My update query is not working:
"UPDATE tblMitglieder SET tblMitglieder.DateAct = DateAct + (second(DateAct)+1) where IDMit = 2;"
Where is the mistake? Thanks for help

 

[arnelgp]

use DateAdd() function:

"UPDATE tblMitglieder SET tblMitglieder.DateAct = DateAdd('s', 30, DateAct) where IDMit = 2;"

you can also use Constant:

"UPDATE tblMitglieder SET tblMitglieder.DateAct = DateAct + #00:00:30# where IDMit = 2;"

or

"UPDATE tblMitglieder SET tblMitglieder.DateAct = DateAct + 0.000347222222222222 where IDMit = 2;"

 

[wanzi]

use DateAdd() function:

"UPDATE tblMitglieder SET tblMitglieder.DateAct = DateAdd('s', 30, DateAct) where IDMit = 2;"

you can also use Constant:

"UPDATE tblMitglieder SET tblMitglieder.DateAct = DateAct + #00:00:30# where IDMit = 2;"

or

"UPDATE tblMitglieder SET tblMitglieder.DateAct = DateAct + 0.000347222222222222 where IDMit = 2;"

Many Thanks, works wonderfully