DSXchange

How do i say that use 24 hour format or not to use 24 hour format in this below function.

Oconv(@time, "MTS")

oh got it

OCONV(TIME(),"MTHS"))

Ray has already answered this question.

Lose the "H" from the time conversion, which specifies a 12-hour clock. No "H" specifies a 24-hour clock.

Handy, that Search functionality!

Yeah....... i wish this search engine was more user friendly.....! like word suggestions etc like google ....! i know one day it will be much more better than it is today.