By using this website, you agree to our Terms of Use (click here)
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.
Thank you.
Moira Peterson
What would make this a lot easier would be a FORMAT function in Generic Inquiries. For more on that:
https://feedback.acumatica.com/ideas/ACU-I-1648
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):
=Right('0'+CStr(Hour([SOOrder.CreatedDateTime])),2)+':'+Right('0'+CStr(Minute([SOOrder.CreatedDateTime])),2)+':'+Right('0'+CStr(Second([SOOrder.CreatedDateTime])),2)