Datetime col to show only the time

[Former Member]

I have a datetime col. that has data as this

Appt_DateTime  (datetime,notnull)`12/30/18997:50:00PM

I want to display only the time in this case the 7:50:pm. it can be with or without the seconds, better without them.

in sql something like this but how to do this in a formula?

select cast({qryPtWaitingTme_.ApptTime} as time) [time] from {qryPtWaitingTme_.}

[Former Member · Accepted solution]

ah i see just the TIME function 🙂

[Former Member]

ah i see just the TIME function 🙂