HP3000-L Archives

June 2017, Week 4

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
John Sommer <[log in to unmask]>
Reply To:
Date:
Fri, 23 Jun 2017 15:02:17 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (71 lines)
John, 


YES!!!  That's it.
A flood of memories came back just reading that.


Thank you so much!


-John




-----Original Message-----
From: Pickering, John (NORBORD) (NORBORD) 
Sent: Fri, Jun 23, 2017 1:59 pm
Subject: RE: [HP3000-L] Quiz Day

DEFINE D-DOW INT*2 = MOD(DAYS(SYSDATE),7) ; day of week

Sunday is zero, Monday is 1, ..., Saturday is 6


-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf Of John Sommer
Sent: Friday, June 23, 2017 2:54 PM
To: [log in to unmask]
Subject: [HP3000-L] Quiz Day

All,


I hope the subject didn't induce a memory of school day panic.
I was actually referring to PowerHouse Quiz v8.19.C4.


I would (almost) swear that I used to determine the day-of-the-week within Quiz
to make adjustments to dates.   Example:  If today is Monday, gather records from last Friday.


I'm sure that I could probably pass the HPDAY variable into Quiz via a jobstream, but I was trying to avoid that if I could and do it strictly within Quiz.  I can report SYSDATE, SYSTIME, SYSDATETIME, but not something like SYSDAY.


Has anyone tackled that before?
Is there maybe a PowerHouse system variable that can be set for Quiz to access?
Other?


Thanks for any thoughts and suggestions, John Sommer



* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *



________________________________
Email Disclaimer:
This message, including any attachments, may contain information that is proprietary, privileged and/or confidential and is intended exclusively for the person(s) to whom it is addressed. If you are not the intended recipient or have received this message in error, please notify the sender immediately by reply email and permanently delete the original transmission from the sender, including any attachments, without making a copy.

Avertissement:
Ce message, y compris tous fichiers joints, peut contenir des renseignements qui sont de nature privée, privilégiée et/ou confidentielle et vise exclusivement la(les) personne(s) à qui il est adressé. Si vous n’êtes pas le destinataire visé ou si vous avez reçu ce message par erreur, veuillez en aviser immédiatement l’expéditeur en répondant au courriel et supprimer de façon permanente la transmission originale de l’expéditeur, y compris tous fichiers joints, sans en avoir fait de copie.



* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2