Hi all,
i want to accomplish the following:
i have YRMO FIELD which gives me year and month,but i want to add the date also i.e;
for eg :if i have 200910 in YRMO field then i got to convert into 20091001,where 01 indicates october1.

please help.......

This message has been edited. Last edited by: Kerry,

What is the format of the field ?

If its YYM, then DEFINE OR COMPUTE
DATEYYMD/YYMD = YRMOField ;

It will add the 01 by default.

Thanks.

i want to know how to set 2 dates using set command.
i used this,but not sure is it correct or wrong.
-SET &YRMO = '200905' OR '200807';

is the above way of assigning the dates is correct or not,if its wrong please advice How to assign two dates.

Must be too early in the morning.

What do you want to get from "-SET &YRMO = '200905' OR '200807';" ?

How to set 2 dates using set command.

quote:

Must be too early in the morning.

It's actually early evening here

Swati, in FOCUS just as in pretty much any other language out there a variable can have ONE value at a time unless of course you're dealing with collections (such as arrays or more elaborated structures) which are not fully supported by FOCUS.

If you need to have 2 dates in WebFOCUS, you will need to have 2 different variables each one representing one of the dates you want and you'll write your code to use one or the other depending on business rules that only you know.

-SET &YRMO_A ='200905';
-SET &YRMO_B ='200807';
-SET &CRT_DT = IF (<your_rule_here>) THEN &YRMO_A || '01' ELSE &YRMO_B || '01'; 
...

thanks...

So you want to supply "'200905' OR '200807'", and get two date out the end of the code ?

The first issue is that you are setting the variable incorrectly.

Try -SET &YRMO = '''200905'' OR ''200807''';

Are you trying to get the date to be auto prompted ?

The second thing, is adding the "01" to the end.

Now, if you're relying on the Auto-prompting facility to be able to select a specific date from a drop down list you could attempt something like this:

-DEFAULT &YRMO='200905';
-PROMPT &YRMO.(OR('200905','200807')).Year_Month;
-TYPE &YRMO

Personally I would never use such a structure in any Production report but it has its place when it comes to quick and dirty development a/o debugging.

But the bottom line is, only ONE value will be assigned to your variable. In this case it will be the one you pick when actually running the code.