RegEx to convert standard date to sql date

Keith Clarke keith.clarke at me.com
Fri Sep 30 13:41:05 EDT 2022


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



More information about the use-livecode mailing list