Hello, current theTimeUpdated field has values as 11.18964, 13.89475, 15.05072, .35896, looking to format in SQL as HH:MM AM/PM.
Thanks.
In SQL:
In Crystal Reports:
TimeValue(ToNumber({CI_Item.TimeCreated})/24)
In SQL:
In Crystal Reports:
TimeValue(ToNumber({CI_Item.TimeCreated})/24)
thank you!
*Community Hub is the new name for Sage City