st)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Monday, May 13, 2013 10:44 AM
To: arslist@ARSLIST.ORG
Subject: Re: Converting date formats in set fields action
I think you need to put single quotes around the field for the SQL
SELECT CONVERT(VARCHAR(10), '$zTmpDiscovere
st(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock
Sent: Monday, May 13, 2013 11:21 AM
To: arslist@ARSLIST.ORG
Subject: Re: Converting date formats in set fields action
**
I did try that on Friday but the field was being set to 2000 to my temp
date/time field again (see log below) so I may no
Support Services
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Vaibhav Singhal
Sent: Friday, May 10, 2013 18:59 PM
To: arslist@ARSLIST.ORG
Subject: Re: Converting date formats in set fields action
**
How about calling a direct SQL and parse the
st System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Paul Blasquez
Sent: Friday, May 10, 2013 14:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Converting date formats in set fields action
**
Rick,
Since you're stuck with a flatfile anyway, would it be an option for
***
>
> Support to SPAWAR – IT Service Management Project, Code 54520
>
> QMX Support Services****
>
> Office (619) 524-2303****
>
> ** **
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Rick Cook
> *Sent
:arslist@ARSLIST.ORG] On Behalf Of Rick Cook
Sent: Friday, May 10, 2013 12:26 PM
To: arslist@ARSLIST.ORG
Subject: Re: Converting date formats in set fields action
**
Why would you need to parse or munge the data? The date/time data is stored
as a string, and the client settings determine how
,6) + "/" + $tempfield$
> Result MM/DD/YYY
>
> Set field finaldatefield $tempdate$
>
> Good Luck,
>
> Mark
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock
>
al Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock
Sent: Friday, May 10, 2013 1:03 PM
To: arslist@ARSLIST.ORG
Subject: Converting date formats in set fields action
I don't know if the long week has caught up with me and thi
ge-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock
Sent: Friday, May 10, 2013 1:03 PM
To: arslist@ARSLIST.ORG
Subject: Converting date formats in set fields action
I don't know if the long week has caught up with me and this i
I don't know if the long week has caught up with me and this is a heavy
question for a Friday. I am just not able to figure out how to convert a
date that I am getting from another system in -MM-DD format to the
MM-DD- format that my server uses. For testing purposes I'm just pasting
the ou
10 matches
Mail list logo