Custom Function to Change Character field to TIME
ThDon
Forums
Hi Guys,
Please help me with a function that can convert a Character field to a Time field, i have attached the file withe the time stored as character.
Hi Guys,
Please help me with a function that can convert a Character field to a Time field, i have attached the file withe the time stored as character.
Hello and welcome to the site
Hello and welcome to the site.
I created custome function (attached) that will take the items that have an am or pm and normalize them in a 24 hour clock. Theu use the @ctod command to change them to a time field such as:
@Ctot(#timeConversion(TIME), "HH:MM:SS")
Thanks for the example, that helped out.
Brian