Dan, Here is another technique for a converting variable of type time to a vaiable of type text, and it is very simple.
SET VAR vtime TIME = 10:11:22SET VAR vtxt TEXT = &vtime --This works SET VAR vtxt TEXT = (&vtime) --This does not works But to work, you can't put parenthesis around the expression R Hopkins -----Original Message----- From: Dan Goldberg <[email protected]> To: [email protected] <[email protected]> Sent: Wed, Jan 13, 2021 7:26 am Subject: RE: [RBASE-L] - convert text to time data type #yiv0585473252 #yiv0585473252 -- _filtered {} _filtered {}#yiv0585473252 #yiv0585473252 p.yiv0585473252MsoNormal, #yiv0585473252 li.yiv0585473252MsoNormal, #yiv0585473252 div.yiv0585473252MsoNormal {margin:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0585473252 a:link, #yiv0585473252 span.yiv0585473252MsoHyperlink {color:#0563C1;text-decoration:underline;}#yiv0585473252 span.yiv0585473252EmailStyle21 {font-family:sans-serif;color:windowtext;}#yiv0585473252 .yiv0585473252MsoChpDefault {font-size:10.0pt;} _filtered {}#yiv0585473252 div.yiv0585473252WordSection1 {}#yiv0585473252 Thx guys. I think this gives me an idea! Dan Goldberg From: [email protected] <[email protected]>On Behalf Of Buddy Walker Sent: Wednesday, January 13, 2021 7:13 AM To: [email protected] Subject: RE: [RBASE-L] - convert text to time data type 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E7A21FB%40EXCHANGE10. -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/000d01d6e9be%24865abd40%24931037c0%24%40comcast.net. -- 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/2E4830CEC16615458329D3D83342F8D0014E7A22AE%40EXCHANGE10. -- 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/1025492020.104991.1611898886306%40mail.yahoo.com.
