e.g. smmActivities table and the time here is stored in form of integer values.
How to convert int field into time (am/pm)
=Format(TimeSerial(0,0,Fields!starttime.Value),"hh:mm:ss tt") - 12 hour clock
=Format(TimeSerial(0,0,Fields!starttime.Value),"HH:mm:ss tt") - 24 hour clock
How to convert int field into time (am/pm)
=Format(TimeSerial(0,0,Fields!starttime.Value),"hh:mm:ss tt") - 12 hour clock
=Format(TimeSerial(0,0,Fields!starttime.Value),"HH:mm:ss tt") - 24 hour clock
Woxcafir_poMadison Andrew Payne https://wakelet.com/wake/QewFa1EHoqKAuFLrA6j6x
ReplyDeletereaurakopart