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 *
|