Re: RegEx to convert standard date to sql date

Thanks I'll try that. Looks like just what I neeed. Bob S On Oct 1, 2022, at 04:30 , Kaveh mailto:ka...@rivervalleytechnologies.com>> wrote: Search for (\d\d)\/(\d\d)\/(\d\d\d\d) replace with \3\1\2 See here On Fri, 30 Sept 2022 at 23:46, Bob Sneidar via use

Re: RegEx to convert standard date to sql date

Search for (\d\d)\/(\d\d)\/(\d\d\d\d) replace with \3\1\2 See here 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 dat

Re: RegEx to convert standard date to sql date

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 > wrote: > > Why not : > set itemdel to "/" > get tD

Re: RegEx to convert standard date to sql date

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

Re: RegEx to convert standard date to sql date

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 > wrote: > > I'm trying to convert a date

Re: RegEx to convert standard date to sql date

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/ to an sql date format > mmdd. Any id

RegEx to convert standard date to sql date

I'm trying to convert a date format like mm/dd/ to an sql date format mmdd. 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, unsub