Re: SV: Preparing import file with date fields in Excel SOLVED

ick W" >Subject: Re: SV: Preparing import file with date fields in Excel >To: arslist@ARSLIST.ORG > >The TEXT function will format an Excel date into whatever format you specify. >For normal US format it would be > . . . &CHAR(34)&TEXT(O2,"MM/DD/ HH:M

Re: SV: Preparing import file with date fields in Excel

mported. As long as the data doesn't change between exports it should work, but one little glitch and everything is all out of sync. Thanks again, Dwayne Original message >Date: Thu, 7 May 2009 17:17:01 +0200 >From: Jonas Stumph Stevnsvig >Subject: SV: Preparing impo

Re: SV: Preparing import file with date fields in Excel

rts it should work, but one little glitch and everything is all out of sync. Thanks again, Dwayne Original message >Date: Thu, 7 May 2009 17:17:01 +0200 >From: Jonas Stumph Stevnsvig >Subject: SV: Preparing import file with date fields in Excel >To: arslist@ARSLIST.OR

SV: Preparing import file with date fields in Excel

with regards, Jonas Stumph Stevnsvig Remedy Developer BEC Intern IT jonas.stumph.stevns...@bec.dk -Oprindelig meddelelse- Fra: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] På vegne af Dwayne Martin Sendt: 7. maj 2009 17:09 Til: arslist@ARSLIST.ORG Emne: P

Preparing import file with date fields in Excel

Dear List, This is really an Excel question, but I can’t find the answer so I’ll try you all. I am trying to create a template for exporting data from one form and importing it into a very different form. So I’ve exported the data from the first form into a comma-separated-file (csv), and ope