Try this. Use the strip function (SSTRIP(source, chars)) to strip the space and the AM or PM from the text. Ex. SET VAR vstrip TEXT = (SSTRIP(8:00 AM, ' APM'))
Then set the next var to TIME this var. EX. SET VAR vtime TIME = .vstrip James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] <[email protected]> On Behalf Of Dan Goldberg Sent: Wednesday, January 13, 2021 8:58 AM To: '[email protected]' <[email protected]> Subject: [RBASE-L] - convert text to time data type CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on any links or opening attachments. 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/CH2PR02MB68218543DA652FA802F4B9A7A0A90%40CH2PR02MB6821.namprd02.prod.outlook.com.
