Re: Date question

[Peter Dow <petercdow@xxxxxxxxx>]

Hi Bill,

Put your alpha date into yyyy-mm-dd-hh-nn.ss.000000 format, then use the 
%timestamp bif (built-in function):

MyString = '1960-09-29-12.34.56.000000';
MyTimeStamp = %timestamp(MyString);

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx>/


On 5/17/2013 1:15 PM, William Howie wrote:
> Hello all,
>
> I have a situation where I need to take an alpha field containing a date in the format of '99/99/9999' and load it into a field of type 'Z' (timestamp).  The program I'm doing this in is free-format.   Any suggestions?   Thanks in advance!
>
> Bill
> ________________________________
> Confidentiality Notice: This email message is intended only for the individual or entity to which it is addressed. This email may contain information that is proprietary or privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you received this email by accident, please notify the sender immediately and destroy this email and all copies of it.