Skip to main content
Solved

How do I get a Created on Field to show the full date and time?

  • April 30, 2026
  • 1 reply
  • 10 views
E
Varsity I
Forum|alt.badge.img

For the service orders and Appointments in the Service Management module, I wanted to add a column that will show the not just the date but also the Time a Service order/ Appointment was created for example 3/30/26 11:40 am

 

We have had it happen a few times where a customer questioned why it was an after hours call.  Currently the column on the GI is a field called FSServiceOrder.CreatedDateTime but it only displays the date and not the time. 

 

I know the time information is also stored in there but only the date is displayed.  I have a workaround in this case because I pulled it into excel and was able to see the full date/time info but I would like to revise it so that it shows on the GI view.   I know there are date functions I tried using those but I can’t see to get it so it shows the full date and time. 

Best answer by BenjaminCrisman

​@eucciferri35 You need to add the field like =[FSServiceOrder.CreatedDateTime] this will display it just as it is seen in the DB

1 reply

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • Answer
  • April 30, 2026

​@eucciferri35 You need to add the field like =[FSServiceOrder.CreatedDateTime] this will display it just as it is seen in the DB

    Terms & ConditionsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved