Sage 100

 View Only
  • 1.  Crystal Formula to convert String to Time

    Posted 03-27-2024 16:19

    I use the following formula to convert a String Time field to HH:MM pretty successfully; but it is not working today on a field and I'm looking for help.  
    Field is:  JT_DailyTimeEntry.StartTime  It is a 4-digit String Field.   Formula that has worked for me before is here.  The formula is returning a time, but it is wrong.  Maybe something with the field and how it is in Operations Management?  I don't know.  Any suggestions or advice? 

    ctime(cdbl({FieldNameHere})/24)



    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------


  • 2.  RE: Crystal Formula to convert String to Time

    Posted 03-27-2024 17:54

    This is what I use:

    TimeValue(ToNumber({CI_Item.TimeCreated})/24)



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------