Preparing import file with date fields in Excel

2009-05-07 Thread Dwayne Martin
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

SV: Preparing import file with date fields in Excel

2009-05-07 Thread Jonas Stumph Stevnsvig
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: Preparing import file

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

2009-05-07 Thread Dwayne Martin
. Thanks again, Dwayne Original message Date: Thu, 7 May 2009 17:17:01 +0200 From: Jonas Stumph Stevnsvig jonas.stumph.stevns...@bec.dk Subject: SV: Preparing import file with date fields in Excel To: arslist@ARSLIST.ORG Hi dwayne - I am using a localized version of excel, but I've

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

2009-05-07 Thread Grooms, Frederick W
the second has the AM or PM indicator Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Thursday, May 07, 2009 1:00 PM To: arslist@ARSLIST.ORG Subject: Re: SV: Preparing import file with date fields in Excel

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

2009-05-07 Thread Dwayne Martin
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:MM:SS)CHAR(34). . . Or . . . CHAR(34)TEXT(O2