>That works great Sergey, if I'm working with a datetime() value. In my case the value I want to increment by one minute is a time() value.
>
>Tim
>
>>>I'm sure there is a simple solution for this, but I'm out of ideas. I want to add one minute to a time() value. Something like:
>>>
>>>lctime = time() + 60 seconds()
>>
>>
lcTime = TRANSFORM( RIGHT( TTOC(DATETIME() + 60,1), 6), "@R 99:99:99")
What you want to receive if you add a minute to 23:59?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.