Hi Stephen, I had to do the same thing earlier today. I used Excel in the end, but only good for < 65000 records. A bit clumsy but did the job in half the time it would take me to research an SQL script.
Procedure was export request id and existing date/time field to CSV. Convert to XLS and create new column and copy existing date/time to it. Format column dd/mm/yy. Save back to CSV. Remedy Import (update old record with new record) request id and new date only field. Leaves system Modified Date as was. Gav -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: 13 July 2007 13:35 To: [email protected] Subject: Convert to Remedy DATE field with SQL List, I added a Remedy DATE field (not DATE/TIME) to an existing form that has many records. I need to backfill the existing entries with the Date portion of an existing Date/Time field. What SQL command will populate a Remedy Date field with the date portion of a Remedy Date/Time field? I looked at threads "Diary Field, Convert Seconds to Date" (May 1, 2007) and "Question regarding "Date" field NOT the "Date-Time" field" (April 19, 2007). I realize that the Remedy Date field represents the number of days since Jan 1, 4713 BC. I know I can accomplish this with a filter but it would take a long time to run, and would update the Modified Date field on each record. With SQL it would take only a few seconds to run. Thanks. SQL Server 2000 ARS 6.3 Stephen ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ************************************************************************ The information contained in this message or any of its attachments may be confidential and is intended for the exclusive use of the addressee(s). Any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited without the express permission of the sender. The views expressed in this email are those of the individual and not necessarily those of Sony or Sony affiliated companies. Sony email is for business use only. This email and any response may be monitored by Sony to be in compliance with Sonys global policies and standards _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
