Hi,
My requirement is to sort dates which are in alphanumeric format in ascending order. I am facing an issue especially when I have dates (say 12-01-04,01-01-05). The dates are sorted in this order 01-01-05, 12-01-04). It should be sorted in the ascending order from the year 04 to 05.

TABLE FILE SQLOUT
PRINT
metric1/D16.4
attr2
AND COMPUTE
COMPUTE TRANSDATE/YYMD = HDATE(attr2, 'YYMD');
TIMELINE1/I6MDY =DATECVT(TRANSDATE, 'YYMD', 'I6MDY');
TIMELINE/A8=EDIT(TIMELINE1,'99-99-99');
ON TABLE HOLD
END

GRAPH FILE HOLD
SUM
metric1/D16.4 AS ''
ACROSS TIMELINE AS ''
ON GRAPH SET 3D OFF
ON GRAPH SET STYLE *
TYPE=DATA, ACROSSCOLUMN=metric1, COLOR=RGB(154 51 255), $
ENDSTYLE
END

Can anyone please suggest a solution for this issue?

Thanks,
Suji.

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

Use a formatted Smart Date and your dates should sort correctly in the graph.

COMPUTE TRANSDATE/YYMD = HDATE(attr2, 'YYMD');
COMPUTE TIMELINE/M-D-Y = TRANSDATE ;

Yes. It is working fine. I have another question.
COMPUTE TIMELINE/MDY = TRANSDATE ;
I need to get date values in this format '01232005' and they have to be sorted in ascending order. But I dont want to have '/' slashes in between the dates. Can you please suggest a solution .

Thanks,
Suji.

Try this:

COMPUTE TIMELINE/M|D|YY = TRANSDATE ;

"M|D|YY" hmmm, very interesting!

Or, sort by a date field but display the alhpa field:

TABLE FILE SQLOUT
PRINT 
metric1/D16.4 
attr2
AND COMPUTE
COMPUTE TRANSDATE/YYMD = HDATE(attr2, 'YYMD');
TIMELINE1/I6MDY =DATECVT(TRANSDATE, 'YYMD', 'I6MDY');
TIMELINE/A8=EDIT(TIMELINE1,'99-99-99');
ON TABLE HOLD
END

GRAPH FILE HOLD
SUM 
metric1/D16.4 AS ''
ACROSS TRANSDATE NOPRINT
ACROSS TIMELINE AS ''
ON GRAPH SET 3D OFF
ON GRAPH SET STYLE *
TYPE=DATA, ACROSSCOLUMN=metric1, COLOR=RGB(154 51 255), $
ENDSTYLE
END

Hi,
Can someone suggest a solution for implementing date in the format 'MD'? I tried using 'M|D' . But it is throwing an error.

Thanks,
Suji.

Hi,
Can someone suggest a solution for displaying date in the formats (MD and Mt-Y)?

For example,
1224,1230 (MD Format)
Jan-09,Dec-09,Jan-10 (Mt-Y format)

Thanks,
Suji.

This assumes your attr2 date is in DATE-TIME format.

DATEMD/HMDN   = attr2 ;
DATEMTY/HMtY- = attr2 ;

This link provides detailed info about formatting DATE-TIME fields:

http://documentation.informati..._desdat/04dd14_2.htm

This link provides detailed info about formatting Smart Dates:

http://documentation.informati...rts436/1_aarpt10.htm

Dan,
DATEQY/HQY- = attr2 ;
I want to specify the quarterly information of the year. But this syntax is not working.(say Q1-2009,Q2-2010 etc).

Thanks,
Suji.

Suji,

Please specify exactly which date format you would like. It started off with MDY and has now evolved to HQY.

There are several types of date formats, with functions and formats particular to each.

What is the input field format and what is the format you would like?

Since date-time formats do not support quarterly output, you will have to convert your date-time value to a Smart Date.

TRANSDATE/YYMD = HDATE(attr2, 'YYMD');
DATEQY/Q-YY    = TRANSDATE ;

This message has been edited. Last edited by: Dan Satchell,

Dan,

It was a real surprise to me that HYYQ is not supported, yet the word "quarter" is defined as a component of date-time fields.

Francis,

Yes, for me too! And function HADD can be used to add/subtract a quarter, and HPART and HNAME to extract the quarter component.

Well then, I'm opening a case to get an explanation!

Apparently it will take a New Feature Request to add HYYQ and HYQ format to WebFOCUS Date-Time fields, so open a case with Tech Support.