Hi Guillermo,
In order for the date to be converted correctly from the character field to
the date/time field, the format of the date string probably needs to match
the format you are seeing in the date/time field. So, if the date/time is
showing up under this format:
12/31/69 18:00:11
Then your original date string probably needs to be in this format to be
converted correctly:
MM/DD/YY HH:MM:SS (24-hour format *without* am/pm)
--Thomas
----- Original Message -----
From: "Guillermo Alfredo Torres Barron"
<[EMAIL PROTECTED]>
Newsgroups: gmane.comp.crm.arsystem.general
To: <[email protected]>
Sent: Tuesday, March 11, 2008 11:35 AM
Subject: Convert string to Date/Time
Hi dear listers
I have a string field with a Date but I need copy this date to a Date/Time
field, the format date on the string field is
mm/dd/yyyy hh:mm:ss a.m./p.m.
When I use a Set Field action for copy the string value to the date/time
field appear the next in this field
12/31/69 18:00:11
How can I convert string to the date/time value?
Thanks in advance
Greetings from Mexico City
__________________________________________
Atentamente
Guillermo Alfredo Torres Barrón
Proyectos ARS Remedy
Grupo Financiero Banorte
Calzada de Tlalpan #2980, Col. Ejidos de
Santa Ursula Coapa, C.P. 04850
México, D.F.
Tel Directo: 51746520, ext: 8505-2520
...........................................................................................
Este correo electronico es confidencial y/o puede contener informacion
privilegiada.
Si usted no es su destinatario o no es alguna persona autorizada por este
para recibir sus correos electronicos, NO debera usted utilizar, copiar,
revelar, o tomar ninguna accion basada en este correo electronico o
cualquier otra informacion incluida en el, favor de notificar al remitente
de inmediato mediante el reenvio de este correo electronico y borrar a
continuacion totalmente este correo electronico y sus anexos.
Nota: Los acentos y caracteres especiales fueron omitidos para su correcta
lectura en cualquier medio electronico.
This e-mail is confidential and/or may contain privileged information.
If you are not the addressee or authorized to receive this for the
addressee, you must not use, copy, disclose, or take any action based on
this message or any
other information herein, please advise the sender immediately by reply this
e-mail and delete this e-mail and its attachments.
...........................................................................................
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
