Time of Day - Remove/Change "AM/PM"

Question

This can be disregarded - I found a solution.Thanks,------------------------------

prashantmaheshw · Answer

The first rule of finding a solution .... is to post the solution for others------------------------------Prashant Maheshwari------------------------------

markshnier__you · Answer

I agree.I had this one ready to go, but did not post it as the question was withdrawn.This would be a formula text field used to display only, not in date calculations.var text ConvertAM = SearchAndReplace(ToText([My Date/Time Field]), "AM", "Z");SearchAndReplace($ConvertAM, "PM", "Z")------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

aidonolligschla · Answer

Thank you for your time.&nbsp; I completely forgot about the box for selecting "24-hour time."&nbsp; This defaults to a HH:MM format with no am or pm at the end, which will work for our application.I believe I could also use a right(5, "Z") function to add the "Z" to the end of each time as well.------------------------------Aidon Olligschlager------------------------------

Forum Discussion

Time of Day - Remove/Change "AM/PM"