Re: Date question

[Peter Dow <petercdow@xxxxxxxxx>]

I should've mentioned that if some of the dates might be invalid, you 
should use a Monitor group to trap the error and do whatever is appropriate.

AlphaDate = '05/17/2013';

monitor;
MyString = %subst(AlphaDate:7:4) + '-'
    + %subst(AlphaDate:1:2) + '-'
    + %subst(AlphaDate:4:2) + '-'
    + '00.00.00.000000';
MyTimeStamp = %timestamp(MyString);
on-error;
    // do whatever is appropriate
endmon;

--
*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.