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 <[email protected]>: > 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:[email protected]] On Behalf Of Jonas Stumph Stevnsvig > Sent: Tuesday, August 09, 2011 5:54 AM > To: [email protected] > 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"
