I'm trying to use the "SET-" operation to take today's date (in the &YYMD format) and have it show up with just the Month and 4-digit year (ie Sep 2018).
With a million combinations of date formats, I can't quite figure out which ones will make it show up correctly.
Using v8.1.05
Any suggestions?This message has been edited. Last edited by: FP Mod Chuck,
I'm still not sure what the use case is for these contortions. There are plenty of ways to get these formats with DEFINE and TABLE but I'm at a loss why one needs an &VARIABLE that has these values.
Just saying!
WebFOCUS 8206, Unix, Windows
September 06, 2018, 05:17 PM
Waz
quote:
I'm at a loss why one needs an &VARIABLE that has these values
From my experience, the longer you've been in the business, the more you find the need for these "obscure" variables.
My guess is that an important customer has asked for it.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
September 07, 2018, 08:40 AM
BabakNYC
My point is there are many ways to display different date formats in a report. The point of populating an &Variable with a value is to use it in a WHERE test or pass it to a drill down report. In either case, having an &Variable set to SEP 2018 doesn't seem to help with a WHERE test. That's why I'm wondering what other use is there in having that value in an &Var.
WebFOCUS 8206, Unix, Windows
September 07, 2018, 09:04 AM
Tony A
quote:
what other use is there
Display as in a heading?
Don't forget that there are &DATEDMYY, &DATEDMtrYY and the various alternatives. Give the option and it will be used!!
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
September 07, 2018, 09:20 AM
Deej
quote:
Originally posted by BabakNYC: I'm wondering why you need this format in a Variable. Will you be using it in a report as a parameter?
Using as a dynamic column heading on a year-over-year revenue report. First column is this month (Sep 2018), second column is same month last year (Sep 2017), etc.