Hi,

I could see the date function for year, month etc, but not quarter.
Could you please help me in creating Quarter field in SQL Calculator using SQL columns in iWay(Data Management Console).

Thanks,
Renuka

What you need to do is define a field in the metadata (Master File Description .mas file) called something like Quarter with the format of Q and have it equal a date field (I believe the field needs to be of format something like YYMD, YYM, YM, MYY, MY, MDYY etc..).

Hi,

As there is no format of Q in the date functions in .mas

Is there any function to extract Quarter from the date.

Thanks,
Renuka

There is no /Q date format, just as there is no /M format: Without a Year component, M and Q are just components (with limited range), not points in an unlimited series of "dates".

Cast your /YYM to /YYQ, and that to /I5YYQ, and extract its units digit via EDIT(,'$$$$9') or IMOD(,10,) to a /I1.

Perhaps you want to try getting the quarter of the date from the data source.

Oracle, for example, has the very usefull TO_CHAR() and TO_DATE() functions.