Formatting Date / Time to pull only time
Is there a way in SOOrder to pull the field CurrentDockAppointmentTime in an HH:MM;TT format? I created an update generic inquiry that I would like the users to be able to mass update dock appointment times. The field CurrentDockAppointmentDate works fine, it allows them to enter the date format but the time field does not. I have run out of options to try.
What would make this a lot easier would be a FORMAT function in Generic Inquiries. For more on that:
For now, what about something like this? It doesn't have the AM/PM, but it's a start (I'm using a different field than you, but you get the idea):