DebbieChapman
Programmer
I have a table with 2 fields Date and time, the format of which are 23/01/2003 and 23.59.01 (hh:mm:ss) is there a way to merge these fields so that if I had to add, say 30 seconds, i could then make the datetime to be 24/01/2003 00:00:31.
At the moment I can add the time, but this causes problems it the time i am looking for goes into another day.
At the moment I can add the time, but this causes problems it the time i am looking for goes into another day.