Regex is overkill for this ..... i would handcode the translation like Keith mentioned.
On Fri, Sep 30, 2022 at 1:42 PM Keith Clarke via use-livecode < use-livecode@lists.runrev.com> wrote: > 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 < > use-livecode@lists.runrev.com> 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 > > use-livecode@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode