Hi,

Does any one know jow to convert a date which is in this "HYYMDS" to "YY-M" format.

Waiting for the replies

Thank you,
Priya

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

Try this:

DEFINE FILE CAR
 XDATE/HYYMDS WITH COUNTRY = DT(&YYMD 09:43:07);
 YDATE/YY-M = HDATE(XDATE,'YYMD');
END
-*
TABLE FILE CAR
 PRINT XDATE YDATE
 WHERE RECORDLIMIT EQ 1 ;
END

You could also put an order in for the book called 'Almost 1001 Ways to work with Dates'. Costs only 25 $ and it is worth that amount ten times over.

RTFM

Read The Functions Manual

Thank you All ...it worked ...i tried Dan's suggestion ...

Priya,

For your own benefit, it might be sensible to have a digital copy of the "Using Functions" manual so that you have quick access to answers like this (also remember that the search above will help you find answers too).

To get a copy of the manual, go to http://www.informationbuilders.com and hover over the link for "Services and Support". Then move your cursor over the link for "Documentation & Technical Library". In the left hand column, click the top option - "Technical Documentation Library" - this will give you a page that will allow you to search the technical documents. Use the search string "Using Functions" and you should be able to identify the correct manual for the version that you use.

Good luck

T