RegEx to convert standard date to sql date

[Bob Sneidar]

Thanks I'll try that. Looks like just what I neeed.

Bob S


On Oct 1, 2022, at 04:30 , Kaveh <kaveh at rivervalleytechnologies.com<mailto:kaveh at rivervalleytechnologies.com>> wrote:

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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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