IF your using the value to calculate in a variable SET VAR vtime TIME If your time formatting is without ap/pm it will automatically drop the AM or PM So 10:00 AM will become 10:00:00 as a time data type
On Thu, Jan 14, 2021 at 1:26 AM Dan Goldberg <[email protected]> wrote: > 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 to [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 > <https://groups.google.com/d/msgid/rbase-l/000d01d6e9be%24865abd40%24931037c0%24%40comcast.net?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/2E4830CEC16615458329D3D83342F8D0014E7A22AE%40EXCHANGE10 > <https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E7A22AE%40EXCHANGE10?utm_medium=email&utm_source=footer> > . > -- Regards Tony -- 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/CABnhDARkjife8EEM%3Dp4A2UvFdvM5w73_DrF4gOB474y1ERsytw%40mail.gmail.com.
