If it's always this standard string 'tDate' why not avoid Regex and just set the delimiters of tDate to "/" and then put item 3 of tDate & item 2 of tDate and put item 1 of tDate? Best, Keith
> On 30 Sep 2022, at 18:13, Bob Sneidar via use-livecode > <[email protected]> wrote: > > I'm trying to convert a date format like mm/dd/yyyy to an sql date format > yyyymmdd. Any ideas? Nothing I found on the interwebs seems to work. > > Bob S > > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
