Hello, Does anyone know how to retrive current date, year etc. as strings in temp variables? I am using FOCUS 7.3.6 under Z/OS using ISPF. Regards, TusharThis message has been edited. Last edited by: <Toshu>,
May 09, 2009, 01:55 PM
FrankDutch
try &YYMD.... see what you get
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
Formatted in the same way as Focus dates: &DATEDMYY=09/05/2009 &DATEDMTYY=09 MAY 2009 etc...
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
May 11, 2009, 04:55 AM
<Toshu>
Hi Danny Thanks for the reply. But need further help. I have to compare myyear with current year in table command. TABLE FILE FILE9 PRINT * WHERE (SITE EQ 'C' OR SITE EQ 'T') AND LSPNAME NE ' ' AND (LSP NE ' 900' AND LSP NE ' 0') AND (EDCD EQ ' ' OR EDCD EQ 'M' OR EDCD EQ 'N') AND (SUBSTR(8,DT,1,4,4,'A4') EQ &Y) END -RUN i tried eq as &yy and othrs. but it is throwing error in syslog : (FOC295) A VALUE IS MISSING FOR: Y
What to do?
May 11, 2009, 05:26 AM
<Toshu>
Thanks Danny! It worked. I was doing wrong. Thanks a lot!