Re: Converting date formats in set fields action

2013-05-13 Thread Rick Westbrock
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

Re: Converting date formats in set fields action

2013-05-13 Thread Grooms, Frederick W
) [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

Re: Converting date formats in set fields action

2013-05-13 Thread Rick Westbrock
@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

Converting date formats in set fields action

2013-05-10 Thread Rick Westbrock
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

Re: Converting date formats in set fields action

2013-05-10 Thread Brittain, Mark
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

Re: Converting date formats in set fields action

2013-05-10 Thread Joe D'Souza
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

Re: Converting date formats in set fields action

2013-05-10 Thread Rick Cook
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

Re: Converting date formats in set fields action

2013-05-10 Thread Rick Westbrock
) [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

Re: Converting date formats in set fields action

2013-05-10 Thread Paul Blasquez
*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

Re: Converting date formats in set fields action

2013-05-10 Thread Rick Westbrock
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