RegEx to convert standard date to sql date

Kaveh kaveh at rivervalleytechnologies.com
Sat Oct 1 07:30:21 EDT 2022


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 at 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 at 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 at 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 at 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 at 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 at 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*


More information about the use-livecode mailing list