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?
LinkedIn
Twitter
