CHOOSE current-date

Michael Lee mcl_systems@bc.sympatico.ca
Wed, 08 Sep 1999 04:52:31 -0700


I don't have access to Powerhouse right now as I'm stuck here in Florida at the
user conference (life's rough) but I think you can do the following:
CHOOSE DATE-FIELD (SYSDATE)

I may be wrong on this but give it a shot.

Michael Lee
MCL Systems Inc.


Johan Koelewijn wrote:

> Hello Bob,
>
> You can put the value of sysdate in a systemvalue and use that systemvalue
> for your choose. That's the way we do it.
>
> Johan Koelewijn
> Van Dijk Delft BV
>
> -----Oorspronkelijk bericht-----
> Van: Bob Feighner <bfeighnr@mailclerk.ecok.edu>
> Aan: powerh-l@lists.swau.edu <powerh-l@lists.swau.edu>
> Datum: dinsdag 7 september 1999 23:47
> Onderwerp: CHOOSE current-date
>
> >I can't believe that I haven't tried this before, but it must be the case.
> >
> >I want to use a QUIZ statement
> >'CHOOSE A-DATE SYSDATE'
> >where A-DATE is a key to the IMAGE detail data set residing on our HP3000
> and
> >receive this error message.
> >
> >*E* Expected:  @  .  GENERIC  NOGENERIC  PARM  SYSTEMVALUE  ,  (  <number>
> >      <eol>
> >
> >If I change it to
> >'CHOOSE A-DATE 19990907', all is well.
> >
> >If I change it to
> >'SELECT IF A-DATE = SYSDATE', all is well (except that it does a serial
> read on
> >the file.
> >
> >I want to run this daily without having to 'seed' the command file with the
> date
> >every time.
> >
> >I'm guessing that this is trivial for someone.
> >
> >Help, please and Thanks In Advance.
> >
> >Bob
> >
> >- Bob Feighner
> >- Director, Computer Services
> >- 159 Administration Building
> >- East Central University
> >- Ada, OK  74820
> >- bfeighnr@mailclerk.ecok.edu
> >- phone:   580/310-5256
> >- FAX:     580/436-4563
> >- http://www.ecok.edu
> >
> >
> >= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> >Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> >Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> >powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> >This list is closed, thus to post to the list, you must be a subscriber.
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.



= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.