Search for (\d\d)\/(\d\d)\/(\d\d\d\d) replace with \3\1\2 See here <https://regex101.com/r/yleq5u/1>
On Fri, 30 Sept 2022 at 23:46, Bob Sneidar via use-livecode < use-livecode@lists.runrev.com> wrote: > Well it's like this. I am working in a document management system, and > when I capture a date, I want to convert it to an sql date. I am not > working in Livecode for this. > > Bob S > > > > On Sep 30, 2022, at 10:38 , Jacques Clavel via use-livecode < > use-livecode@lists.runrev.com> wrote: > > > > Why not : > > set itemdel to "/" > > get tDate > > put item 3 of it & item 1 of it & item 2 of it into tSql > > > > JC > > > > Le ven. 30 sept. 2022 à 19:13, Bob Sneidar via use-livecode < > > use-livecode@lists.runrev.com> a écrit : > > > >> 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 > >> > > > > > > -- > > Jacques Clavel > > _______________________________________________ > > 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 > -- Kaveh Bazargan PhD Director River Valley Technologies <http://rivervalley.io> ● Twitter <https://twitter.com/rivervalley1000> ● LinkedIn <https://www.linkedin.com/in/bazargankaveh/> ● ORCID <https://orcid.org/0000-0002-1414-9098> *Accelerating the Communication of Research* _______________________________________________ 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