anybody know how to get the MAX of a DATE/yymd field into a header?

i tried  <MAX.DATE ...nada
i tried <LST.DATE ... nada
i tried <TOT.DATE ... zippo
i tried <MAX. DATE  ... nada [with that funny blank you sometimes need for stuff)

argh!!!

This seemed to work for me:

TABLE FILE EMPDATA
HEADING
"The last employee was hired on: <MAX.HIREDATE> </1"
SUM MAX.HIREDATE NOPRINT
PRINT HIREDATE
BY HIREDATE NOPRINT
  BY PIN
END
  

Karen,

You don't say what release you used although I guess it was as per Susannah's signature. I'm not sure that it matters anyway as the code you give is what I would normally do for this anyway!

Susannah,

The important bit of code is, as Karen has, is the SUM MAX.datefield NOPRINT before your next verb object such that is obtains the max date field value at TABLE level which is what you require.

T

i tried that, melbourne, didn't work.
i got nada

i did that.
i got nada
i'm in 764.

Susannah

how about putting the max date in an amper

Hi Susannah,

This may help:

TABLE FILE WHATEVER
SUM
MAX.DATE
ON TABLE SAVE AS MAX_DATE
END
-RUN
-READ MAX_DATE &MAX_DATE.A8.

then use &MAX_DATE in the HEADING

Hope this helps...

very good Tom

Susannah, what Piipster suggested works fine in 7.13. Could this be a bug?

Works in 762 as well.

quote:

TABLE FILE EMPDATA
HEADING
"The last employee was hired on: SUM MAX.HIREDATE NOPRINT
PRINT HIREDATE
BY HIREDATE NOPRINT
BY PIN
END

Actually, works fine in 7.6.4 as well...

yes melbourne's ex works fine in 764 as well. Tom, yes but im trying to avoid the double data pass.
so that confirms the prob is in my sleep-deprived brain.
merci, mes amis.

quote:

but im trying to avoid the double data pass.

Ahhhhhh, a little tid-bit left unmentioned!!!

Doing the -READ is really very quick, especially, if the column is indexed, as I know, that, you know....

Have a great weekend...

P.S. Stop getiing up at 3:30 in the morning!!!!

aha.
this works

TABLE FILE EMPDATA
HEADING
"min hire date <MIN.HIREDATE  TO max <MAX.HIREDATE> </1"
SUM MAX.HIREDATE NOPRINT
SUM  
-*CNT.DST.PIN
SALARY BY DEPT
END

but this doesn't

TABLE FILE EMPDATA
HEADING
"min hire date <MIN.HIREDATE  TO max <MAX.HIREDATE> </1"
SUM MAX.HIREDATE NOPRINT
SUM   
CNT.DST.PIN  
SALARY BY DEPT
END

Its the count distinct that blows it slam out of the water. rats. its 2pass time.
you don't even need the first SUM
Is this a bug or a feature?

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

Yes, Tony, unless I say otherwise I use the version and OS specified in the thread.

For example for my next version of this code I used WF R714 on Windows 2003 EE.

Renaming the MAX.datefield and putting the HEADING at the bottom seems to work with one pass:

TABLE FILE EMPDATA
SUM 
MIN.HIREDATE NOPRINT
COMPUTE MIN_DATE/YMD = MIN.HIREDATE; NOPRINT
MAX.HIREDATE NOPRINT
COMPUTE MAX_DATE/YMD = MAX.HIREDATE; NOPRINT
SUM   
CNT.DST.PIN  
SALARY BY DEPT
HEADING
"Date of most recent employee hire: <MAX_DATE "
"First employee hired on: <MIN_DATE </1"
END

Thank you ,Melbourne!

Karen,

I guessed that was the case, I was just ensuring the readers would realise that before jumping headlong in etc......

As for the sequence of code, who would have though that it would make that much difference So much for coding free of sequence requirements

T

Hi Suusannah,

I've never seen the use of multple SUM or PRINT verbs with a single END as illustrated in this post. Isn't the first SUM a "dangling SUM" in that it has no matching END? I think of SUM-END/PRINT-END like parenthesis that must be in matched pairs and am curious about the operation of such multiple 'openings' with only one 'closing'.

Chris

Chris,

This is called a 'multi-verb' request and has been around forever. The major caveat is that the BYs be nested, i.e. either the same or every increasing. The last verb can be a PRINT.

A very useful tool.

To supplement Ginny's excellent explanation, you can also have something like

TABLE FILE yourfile
SUM fieldname
PRINT fieldname
etc. ...

(e.g. without a sort phrase between) to provide a summated value at the top level.

T

Chris...oh you've just stumbled upon *the* coolest thing about wf, double verbs, triple verbs..howevermayyouwant verbs..all to create aggregates at whatever level you need.
and 1 end statement.
Now that you've discovered that, you'll never get any more sleep

T, i did know about the HEADING at the end bit... i learned that one SUMMIT, probably from Renee or Noreen...just a flying one-liner that stuck in my head...ah the value of SUMMIT..
its that COMPUTE to actually get past the CNT.DST aggregation that may not ever have occured to me without the POINT here. And the fact that Melbourne is up earlier than the rest of us. thanks again, downunder.