FWIW, putting parenthesis around, forces it to be TEXT.
Razzak
At 12:41 AM 1/29/2021, 'R Hopkins' via RBASE-L wrote:
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:22
SET 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
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:
<mailto:[email protected]>[email protected]
<<mailto:[email protected]>[email protected]>
On Behalf Of Dan Goldberg
Sent: Wednesday, January 13, 2021 9:58 AM
To: '[email protected]'
<<mailto:[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/0LyWpM-1m0wVB2RuA-015oc4%40mrelay.perfora.net.
