Time Format

hi ,

I have a liitel question.

Maybe easy for advanced developer , But please help me if you can .

I need in my report to have a different formatnof time … <> Format(time,0,0)

the default one is hr :min :sec AM/PM

How can i have other format ?? i need it as hr:min or hr:min AM/PM only … can i have it ?

thank you


try: FORMAT(TIME(),0,’:<Minutes,2> <AM/PM>’)

Josef Metz

thanks josef …thank you a lot … yes it works