Re: RegEx to convert standard date to sql date

[Bob Sneidar via use-livecode]

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

Bob S


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

Search for
(\d\d)\/(\d\d)\/(\d\d\d\d)
replace with
\3\1\2

See here

On Fri, 30 Sept 2022 at 23:46, Bob Sneidar via use-livecode 
mailto:use-livecode@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 
> mailto:use-livecode@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@lists.runrev.com> a écrit :
>
>> I'm trying to convert a date format like mm/dd/ to an sql date format
>> mmdd. Any ideas? Nothing I found on the interwebs seems to work.
>>
>> Bob S
>>
>>
>> ___
>> use-livecode mailing list
>> use-livecode@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@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@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 ● 
Twitter ● 
LinkedIn ● 
ORCID
Accelerating the Communication of Research

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: RegEx to convert standard date to sql date

[Kaveh via use-livecode]

Search for
(\d\d)\/(\d\d)\/(\d\d\d\d)
replace with
\3\1\2

See here 

On Fri, 30 Sept 2022 at 23:46, Bob Sneidar via use-livecode <
use-livecode@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@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@lists.runrev.com> a écrit :
> >
> >> I'm trying to convert a date format like mm/dd/ to an sql date
> format
> >> mmdd. Any ideas? Nothing I found on the interwebs seems to work.
> >>
> >> Bob S
> >>
> >>
> >> ___
> >> use-livecode mailing list
> >> use-livecode@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@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@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  ● Twitter
 ● LinkedIn
 ● ORCID

*Accelerating the Communication of Research*
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: RegEx to convert standard date to sql date

[Bob Sneidar via use-livecode]

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 
>  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@lists.runrev.com> a écrit :
> 
>> I'm trying to convert a date format like mm/dd/ to an sql date format
>> mmdd. Any ideas? Nothing I found on the interwebs seems to work.
>> 
>> Bob S
>> 
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: RegEx to convert standard date to sql date

[Tom Glod via use-livecode]

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@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@lists.runrev.com> wrote:
> >
> > I'm trying to convert a date format like mm/dd/ to an sql date
> format mmdd. Any ideas? Nothing I found on the interwebs seems to work.
> >
> > Bob S
> >
> >
> > ___
> > use-livecode mailing list
> > use-livecode@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: RegEx to convert standard date to sql date

[Keith Clarke via use-livecode]

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 
>  wrote:
> 
> I'm trying to convert a date format like mm/dd/ to an sql date format 
> mmdd. Any ideas? Nothing I found on the interwebs seems to work. 
> 
> Bob S
> 
> 
> ___
> use-livecode mailing list
> use-livecode@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: RegEx to convert standard date to sql date

[Jacques Clavel via use-livecode]

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@lists.runrev.com> a écrit :

> I'm trying to convert a date format like mm/dd/ to an sql date format
> mmdd. Any ideas? Nothing I found on the interwebs seems to work.
>
> Bob S
>
>
> ___
> use-livecode mailing list
> use-livecode@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

RegEx to convert standard date to sql date

[Bob Sneidar via use-livecode]

I'm trying to convert a date format like mm/dd/ to an sql date format 
mmdd. Any ideas? Nothing I found on the interwebs seems to work. 

Bob S


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode