Thanks I'll try that. Looks like just what I neeed. Bob S
On Oct 1, 2022, at 04:30 , Kaveh <[email protected]<mailto:[email protected]>> wrote: 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 <[email protected]<mailto:[email protected]>> 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 > <[email protected]<mailto:[email protected]>> 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 < > [email protected]<mailto:[email protected]>> 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 >> [email protected]<mailto:[email protected]> >> 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 > [email protected]<mailto:[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]<mailto:[email protected]> 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 [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
