Concatenated Time fields getting 24hr time

Austin
Participant V

I am concatenating 2 time fields and I am getting 24 hr time. They are 24hr time CHAR fields in our database so I’m assuming that’s why. How can I force the time to be 12hr when concatenating or do I have to convert them to their 12 hr variant text values before concatenating?

Solved Solved
0 6 223
1 ACCEPTED SOLUTION

Steve
Participant V

Wrap each Time column reference in TEXT().

View solution in original post

6 REPLIES 6

Steve
Participant V

Concatenating? Screenshot?

Steve
Participant V

Wrap each Time column reference in TEXT().

I don’t see a way to get “August 3rd” from the TEXT(), I see how to get August and 3 or 03 but the suffixed date doesn’t seem present. Please tell me it’s in there

It is not.

Yeah, you’re own your own with adding suffixes to the numbers. Luckily that’s really easy to to do programmatically.

Top Labels in this Space