RegEx to convert standard date to sql date

[Bob Sneidar]

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