Skip to main content
Solved

Date & Time Split Error

  • Mar 16, 2023 10:34 AM UTC
  • 1 reply
  • 161 views
  • Translate All
tahirsiddiqui190
Freshman I
Forum|alt.badge.img

i Split Date and time 

but its shows wrong time 

=Right('0'+CStr(Hour([AMClockTran.StartTime])),2)+':'+Right('0'+CStr(Minute([AMClockTran.StartTime])),2)

Best answer by sweta68

 Hi @tahirsiddiqui190 ,

I have used same formula in GI and It shows time in 24 hours format, If you want to display it in 12 Hours format, You can use below formula.

=IIF(HOUR([AMBomItem.CreatedDateTime])<=12,PADLEFT(CSTR(HOUR([AMBomItem.CreatedDateTime])),2,'0')+':'+PADLEFT(CSTR(MINUTE([AMBomItem.CreatedDateTime])),2,'0')+ ' AM',PADLEFT(CSTR(HOUR([AMBomItem.CreatedDateTime])-12),2,'0')+':'+PADLEFT(CSTR(MINUTE([AMBomItem.CreatedDateTime])),2,'0')+ ' PM')

Below is our result using the above formula. 

Note: Just use required field instead of AMBomItem.CreatedDateTime.

Hope, This helps!

Regards

Sweta

View original

      1 reply

      Semi-Pro III
      Forum|alt.badge.img+9
      • sweta68
      • Semi-Pro III
      • Answer
      • Mar 16, 2023 11:18 AM UTC

       Hi @tahirsiddiqui190 ,

      I have used same formula in GI and It shows time in 24 hours format, If you want to display it in 12 Hours format, You can use below formula.

      =IIF(HOUR([AMBomItem.CreatedDateTime])<=12,PADLEFT(CSTR(HOUR([AMBomItem.CreatedDateTime])),2,'0')+':'+PADLEFT(CSTR(MINUTE([AMBomItem.CreatedDateTime])),2,'0')+ ' AM',PADLEFT(CSTR(HOUR([AMBomItem.CreatedDateTime])-12),2,'0')+':'+PADLEFT(CSTR(MINUTE([AMBomItem.CreatedDateTime])),2,'0')+ ' PM')

      Below is our result using the above formula. 

      Note: Just use required field instead of AMBomItem.CreatedDateTime.

      Hope, This helps!

      Regards

      Sweta

      Translate
        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