Skip to main content
Solved

Date & Time Split Error

  • 16 March 2023
  • 1 reply
  • 104 views

i Split Date and time 

but its shows wrong time 

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

1 reply

S
Rank
Userlevel 7
Badge +10

 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

Reply


Terms & ConditionsCookie settings