QMX 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
)
[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 not have
@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), '$zTmpDiscoveredDate$', 101) AS DiscDate
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
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 is a heavy
question for a Friday
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 is a heavy
question
finaldatefield $tempdate$
Good Luck,
Mark
-Original 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
)
[mailto: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
*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 it is displayed
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 you to
process that file
10 matches
Mail list logo