converting 03012012 to 20120312

[dcutaia]

I have a numeric variable and need to convert it to a numeric YYYYMMDD . What is the most efficient way of doing this.

S1DATE = 03012012 8,p
Need S1DATE=20120312 8,p

DAC

[B.Hauser]

Re: converting 03012012 to 20120312

Even though your S1Date is not the same, you may try:

 /Free
    NewNumDate = %Dec(%Date(OldNumDAte: *ISO): *USA);

Birgitta

[Rocky]

Re: converting 03012012 to 20120312

Actually - just backwards... should be:

[COLOR=#000000]NewNumDate = %Dec(%Date(OldNumDAte: *USA): *ISO);[/COLOR]

It's in USA format - wanting to change it to ISO.

[NeilD]

Re: converting 03012012 to 20120312

I always refer to the link below for date conversions.....

http://search400.techtarget.com/tip/RPG-free-format-date-conversion-cheat-sheet

[Scott Klement]

Re: converting 03012012 to 20120312

To save Tommy the trouble:

[Rocky]

Re: converting 03012012 to 20120312

LOL - well if you're like me and you browse through examples to improve one's knowledge - it's always good to know that the examples are valid... whether it's 2 years old or current...

[tomholden]

Re: converting 03012012 to 20120312

To save Tommy the trouble:

thanks lol