Focal Point
[SOLVED]HGETC vs. hard-coded date

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7757081386

July 22, 2016, 10:20 AM
gcarterIT
[SOLVED]HGETC vs. hard-coded date
I have this line of code:

TDY_DATE/HMDYYs = HGETC(8,'HMDYYs');

Its used to generate a report based on today's date.

How can I revise this line so I can hard-code a date other than today?

Thanks.

This message has been edited. Last edited by: <Emily McAllister>,


WebFOCUS 7.6
Windows, All Outputs
July 22, 2016, 10:34 AM
MartinY
Is this what you want ?

DEFINE FILE CAR
TDY_DATE /HMDYYs = HGETC(8,'HMDYYs');
TDY_DATE2/HMDYYs = '07/20/2016 10:11:22.333';
END
TABLE FILE CAR
PRINT TDY_DATE
      TDY_DATE2
BY COUNTRY NOPRINT
WHERE RECORDLIMIT EQ 1;
END



WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
July 27, 2016, 10:57 AM
gcarterIT
Thanks. that works.


WebFOCUS 7.6
Windows, All Outputs