Hi folks,

What do I need to be able to use the MONTH function within Report Painter?

Error I got:

 
-SET &MTH = MONTH(02/16/10);
 0 ERROR AT OR NEAR LINE     51  IN PROCEDURE _get_ly_wkd.fexFOC
 (FOC263) EXTERNAL FUNCTION OR LOAD MODULE NOT FOUND: MONTH
 

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

I don't believe there is a MONTH function in WebFOCUS or MAINTAIN. There is such a function in SQL.

This message has been edited. Last edited by: Dan Satchell,

Hi Marikaki,

If you know that the month is always the first 2 characters, you may want to try using:

  
-SET &MTH 	= EDIT(&PARAMDATE, '99$$$$$$$$');

Best Regards,

Jimmy Pang

I found it in the web Maintain-specific Date and Time Functions documentation.

Is there any easy way to get the month using SET command?

As Dan says there is not such a function (at least that I know of) in WebFOCUS.

If your DATE value resides in a dialog manager &variable (as your example leads me to believe) you may use the EDIT function to extract the piece corresponding to the month.

-SET &MTH=EDIT(&YYMD, '$$$$99$$');

If your value is in an actual DATE field, you have more options; for example, have a new date field with "M" format and assign your actual DATE value to it.

DEFINE FILE CAR
MYDATE/YYMD WITH CAR = &YYMD;
MYMONTH/M = MYDATE;
END
TABLE FILE CAR
PRINT
       CAR
       MYDATE
       MYMONTH
END

Hope that helps!
- Neftali.

fatboyjim, you just beat me to it

Thanks You Jimmy, exactly what I need and easy. I am doing baby steps learning BI-Webfocus.

Not a problem =) Glad it helped =)

Thanks Neftali; I appreciate the fast speed answer you all gave me.

FYI, you cannot use Maintain functions in a report.

Maintain functions are only accessible after the line MAINTAIN [FILE {Master}].

May be a good idea for you to update your signature, so we know what platform and version your using.

Thanks for the info. I will update my signature.