Time of Day - Remove/Change "AM/PM"
This can be disregarded - I found a solution. Thanks, ------------------------------
Forum Discussion
The first rule of finding a solution .... is to post the solution for others
------------------------------
Prashant Maheshwari
------------------------------
------------------------------
Prashant Maheshwari
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendI 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
------------------------------
- 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
------------------------------
