Dan You could create another column newTimeCol and set it to time
UPDATE table SET newTimeCol = oldTextCol This should work as long as each row has AM or PM in it You could also just change the column from text to time. This may caused problems with reports/forms etc. Buddy From: [email protected] <[email protected]> On Behalf Of Dan Goldberg Sent: Wednesday, January 13, 2021 9:58 AM To: '[email protected]' <[email protected]> Subject: [RBASE-L] - convert text to time data type I have a text field that a user selects from for each hour. 8:00 AM 9:00 AM 10:00 AM …. I need to convert that to a time format so I can use it in calculations. I do not see a function to do so. Anyone know how I can convert it? TIA Dan Goldberg -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E7A21FB%40EXCHANGE10 <https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E7A21FB%40EXCHANGE10?utm_medium=email&utm_source=footer> . -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/000d01d6e9be%24865abd40%24931037c0%24%40comcast.net.
