I have one date from one table that is in this format:
YYMD
YYYY/MM/DD

Another Table has the date in this format:

A7 output is like this: MM/YYYY

How do get these to formats to agree. I am trying to use the more statement to append these dates in the same field. I dont particulary need them to look the same but they need to work together. So alphanumeric would be fine if the other doesn't work.

And yes I have search focalpoint but every thing I have looked at doesn't seem to speak to my problem.

Any Help

This message has been edited. Last edited by: moyer1dl,

Is your first field a smart date or an A10?
Strip off the day in the first field and then edit it to be an A7 so it will match the second field.

SMARTDATE

First field is smartdate. Convert it to alpha: compute date/a8yymd = smartdate.
Then use edit to break it up in pieces and put them together again to form the a7 field.

If you need to do more sophisticated date conversions, there is a very good and very readable book: (Almost) 1001 ways to work with dates. DN is 94000251.1106. It costs only 25 $ and is available on the ibi website. I can recommend it to you - you'll be giving advice after reading it in stead of asking for it.

Thanks