Is there any business function or easy way to count the number of months in between two dates. Say October 1st 2001 - April 1st 2004? Any feedback will be appreciated. Thanks.
I have found that data source DN0700003 seems to be what I want. Does anyone know how I would go about using this certain business function. meaning what 2 records do I use to send over the dates?
Thanks for the reply. I have one more question however and hope you may, or anyone else for that matter may have an answer. Is there anyway inside of Report Design inside of JDE to assign a variable with a static date value. For instance, How would I go about assigning 'Variable Date' with the value of 05/01/2002 and it recognize that as a date instead of text? Thanks.
Using B0800013 Convert String To Date, you can assign constant value to a date variable.
The BSFN accept a 10 char length string (alias VC10A) as input in "MM/DD/YYYY" format. Define a string variable based on VC10A, assign the constant date as text to it (e.g. "05/19/2004") and use the BSFN to convert it to your date variable.