I've opened a case for this, but was wondering if anyone else encountered this issue. I have two DEFINE columns in a Master. The column that uses DOWK to determine the day of the week has two issues: 1) the value does not display on all rows; 2) the value is wrong on the ones it does display on.

SET PAGE=NOLEAD
SET HTMLCSS=ON
-RUN

FILEDEF HRUN_LOG1 DISK hrun_log1.ftm
-RUN

-WRITE HRUN_LOG1 20131101022418000
-WRITE HRUN_LOG1 20131101025432000
-WRITE HRUN_LOG1 20131102012709000
-WRITE HRUN_LOG1 20131102103739000
-WRITE HRUN_LOG1 20131103001230000
-WRITE HRUN_LOG1 20131103141206000
-WRITE HRUN_LOG1 20131104105915000
-WRITE HRUN_LOG1 20131104130513000
-WRITE HRUN_LOG1 20131105122830000
-WRITE HRUN_LOG1 20131105160954000
-WRITE HRUN_LOG1 20131106083313000
-WRITE HRUN_LOG1 20131106091953000
-WRITE HRUN_LOG1 20131107010421000
-WRITE HRUN_LOG1 20131108003502000
-WRITE HRUN_LOG1 20131108183708000
-WRITE HRUN_LOG1 20131109090653000
-WRITE HRUN_LOG1 20131110091906000
-WRITE HRUN_LOG1 20131111063959000
-WRITE HRUN_LOG1 20131112065457000
-WRITE HRUN_LOG1 20131113095655000
-WRITE HRUN_LOG1 20131114051059000
-WRITE HRUN_LOG1 20131114051306000
-WRITE HRUN_LOG1 20131115050721000
-WRITE HRUN_LOG1 20131115232203000
-WRITE HRUN_LOG1 20131116091118000
-WRITE HRUN_LOG1 20131116101521000
-WRITE HRUN_LOG1 20131117050757000
-WRITE HRUN_LOG1 20131118110244000
-WRITE HRUN_LOG1 20131119054738000
-WRITE HRUN_LOG1 20131119054934000
-WRITE HRUN_LOG1 20131120031140000
-WRITE HRUN_LOG1 20131120061938000
-WRITE HRUN_LOG1 20131121100253000
-WRITE HRUN_LOG1 20131121100450000
-WRITE HRUN_LOG1 20131122050757000
-WRITE HRUN_LOG1 20131122051345000
-WRITE HRUN_LOG1 20131122112204000
-WRITE HRUN_LOG1 20131123091228000
-WRITE HRUN_LOG1 20131123091823000
-WRITE HRUN_LOG1 20131124090626000
-WRITE HRUN_LOG1 20131125054830000

FILEDEF MASTER DISK hrun_log1.mas
-RUN

-WRITE MASTER FILENAME=HRUN_LOG1, SUFFIX=FIX, IOTYPE=STREAM, $
-WRITE MASTER   SEGMENT=HRUN_LOG1, SEGTYPE=S0, $
-WRITE MASTER     FIELDNAME=END_DATE_TIME, ALIAS=E01, USAGE=HYYMDS, ACTUAL=A17, $
-WRITE MASTER DEFINE END_DATE/YYMD = HDATE(END_DATE_TIME, 'YYMD');
-WRITE MASTER DEFINE END_DATE_DOW/A12 = DOWK(END_DATE, 'A3');

TABLE FILE HRUN_LOG1
SUM
MIN.END_DATE_TIME
MIN.END_DATE_DOW

BY END_DATE

ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON,
FONT='ARIAL', SIZE=9, BORDER=1, BORDER-COLOR=SILVER, $
ENDSTYLE
END
-RUN

TABLE FILE HRUN_LOG1
PRINT
END_DATE_TIME
END_DATE_DOW

BY END_DATE

ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON,
FONT='ARIAL', SIZE=9, BORDER=1, BORDER-COLOR=SILVER, $
ENDSTYLE
END
-RUN

This message has been edited. Last edited by: Francis Mariani,

Well, all of your sample dates are after the Mayan calendar end, so it can't be that ......

Please let us know what the outcome is as it is likely to affect many(?)

T

Hi Francis,

I assumed that you had looked at the documentation on DOWK (and not left it to memory ).

The input for DOWK should be I6YMD or I8YYMD and not smart date. Change your defines and this will work OK. Note that the DOWK is also documented output of A4 not A3.

Do you want the document link?

T

Oh well! Since the DOWK function was grouped under Date functions in the manual I ASSumed the input was a date!

Incidentally , if I follow the documented syntax, I get an error - because the doc specifies indate should be I6YMD or I8YMD, when it should be I6YMD or I8YYMD.

quote:

I6YMD or I8YMD, when it should be I6YMD or I8YYMD

Yes, I seem to remember that "typo" that going back a few versions.

Out of interest, I just looked at my old UWS (the old red one - DN40021.0686 June 1986!!) and on page 14 it states -

Date (Numeric)        The input date in [YY]YYMMDD format.
OUTPUT (Alpha)        The returned day of the week.
Note: Output is an A4 field ....

The example shown does have DAY/A4 WITH COUNTRY=DOWK(801114,DAY); so even then it actually should specify I6YMD or I8YYMD.

I concentrate on trying to remember the myriad of function names so at least I can do a search of the document for the syntax and formats etc. I even had to do that for DOWK.

Obviously been a long week, put your feet up and have a beer


T

Thanks for the solution.

Will do!