Forum Discussion
MarkShnier__You
Qrew Legend
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
------------------------------
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
3 years agoQrew Cadet
Thank you for your time. I completely forgot about the box for selecting "24-hour time." 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
------------------------------
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
------------------------------