sometimes it works better if you put a blank space after the &var in a header or col title, lets focus know the &var isn't called &var, CAR AS '&today ' or CAR AS '&today , yadayada'
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
May 31, 2007, 04:19 PM
thebrettd
Ah sorry, should have been a little more careful with my original post. I want to extract specific parts of the date like so:
define file car TODAY/YYMD = &YYMD; ENDYR/YY = TODAY; end
table file car print car AS 'effective through < ENDYR'
Do any date calculations needed for column headings in Dialog Manager, not defines. Then you can use the resulting amper-variable in the column title, as Leah mentioned. You can not use fields in the column-titles. If you want today's date in a different format, ie just the year, you can find a version of the system date that shows it (ie &DATEYY).
Originally posted by N.Selph: Do any date calculations needed for column headings in Dialog Manager, not defines. Then you can use the resulting amper-variable in the column title, as Leah mentioned. You can not use fields in the column-titles. If you want today's date in a different format, ie just the year, you can find a version of the system date that shows it (ie &DATEYY).
PRINT CAR AS 'Effective thru &DATEYY'
Ah, ok. That is the feeling I was getting after finagling with it for a while.
I don't think you can use field names/values in the AS phrase. What you would want here is just Dialogue Manager stuff:
-SET &ENDYR=CHGDAT('YYMD','YY',&YYMD, 'YY');
If you need it to be dependent on data, you could use DEFINEs to group into individual years and use the correctly calculated values from your -SET commands. YEAR1/D12.2=IF YEAR EQ '&ENDYR1' THEN FIELDNAME ELSE 0; YEAR2/D12.2=IF YEAR EQ '&ENDYR2' THEN FIELDNAME ELSE 0;
and so on. Then PRINT YEAR1 AS '&ENDYR1' YEAR2 AS '&ENDYR2'
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
May 31, 2007, 05:28 PM
thebrettd
Oh Darin. You rock. (had to change your code slightly to get it to run, it was complaining about the last parameter to the function)
Yup - sorry ' bout missing that. DM wouldn't know what a date is, but it does know what alpha is. Rather than use CHGDAT, it would be easier just to set equal to &DATEYY, &DATEMT (1001 WAYS TO GET A DATE OUT OF WEBFOCUS!!)
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat