Jonas, Ok...just spent a few min's with this and figured it out for you. The problem is that when you are doing the + and "/" and etc....remedy is considering it a mathematical formulation in the Date field. So, the solution I came up with is to first do all of your substr functions into the char field that you are using for validations, then set your date field (in another setfield) to the value of your char field. Works like a charm.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jonas Stumph Stevnsvig Sent: Tuesday, August 09, 2011 8:43 AM To: arslist@ARSLIST.ORG Subject: Re: String to Date The server is set to english(us) and expects m/d/yyyy I logged on to the dev tool on the server itself, instead of my workstation, and had a look at the date representation. It matched the server setting. But even after replacing the string with > ((((SUBSTR($ImportedDateCharField$, 4, 5) + "/") + > SUBSTR($ImportedDateCharField$, 6, 7)) + "/") + > SUBSTR($ImportedDateCharField$, 0, 3)) + " 01:00:00" And checking that it resolves to the right string (06/30/2011 01:00:00) i get 9 aug 2011 1:39:07 am as the date... Den 09/08/2011 kl. 15.43 skrev LJ LongWing <lj.longw...@gmail.com>: > What is the regional setting of the server? What format does the windows > server expect dates to be in? > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Jonas Stumph Stevnsvig > Sent: Tuesday, August 09, 2011 5:54 AM > To: arslist@ARSLIST.ORG > Subject: String to Date > > Hi all > > I am having a spot of trouble with strings and dates... > > I have an import which gives me dates in the following format: yyyyMMDD, > and puts them in a Character field. > > I want to parse the date, so i created a setfields action with a value of > ((((SUBSTR($ImportedDateCharField$, 6, 7) + "-") + > SUBSTR($ImportedDateCharField$, 4, 5)) + "-") + > SUBSTR($ImportedDateCharField$, 0, 3)) + " 01:00:00" > > If this is put in another char field the value displayed is "31-05-2001 > 01:00:00" > If I put that value in the date field, I get "Tue, 9 Aug, 11 1:33:57 " > > But if i hard code the textual value "31-05-2001 01:00:00" in the > date/time field - it works great. > > PS I am using the data import tool for the import - I thought I could > define the format in the options pane, but that is apparently only for > displaying - not for parsing date/times ??? > > I hope someone can see where I am going wrong. > > best regards > > Jonas Stevnsvig > > ____________________________________________________________________________ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > > ____________________________________________________________________________ ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
