Hello,
i am trying to create a report, and want to supply the TimeUpdated String(8) field from the IM_PriceCode table.
can i create a formula field to convert that Field to a 12 hour time field? if so.. how?
Thanks for reading.
Peter
Hello,
i am trying to create a report, and want to supply the TimeUpdated String(8) field from the IM_PriceCode table.
can i create a formula field to convert that Field to a 12 hour time field? if so.. how?
Thanks for reading.
Peter
In Crystal Reports something like this should work:
ctime(cdbl({SY_ActivityLog.LogTime})/24)
awesome Kevin.. that worked like a charm!!!!
Credit goes to jepritch ... he posted that formula a while ago, and I've been using it ever since.
so helpful for our users. im glad he did and glad you re-shared!! kudos to you both!
*Community Hub is the new name for Sage City