RegEx to convert standard date to sql date

Tom Glod tom at makeshyft.com
Fri Sep 30 13:49:52 EDT 2022


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


More information about the use-livecode mailing list