Question
I received a request from a client to display Date Requested and the week number of the year this date falls-in. I was surprise to find out that there is not a Business Function in JDE that provides this calculation so we had to create our own BF to this. So how do you create group of tasks to accomplish this?
Answer
Below are the data structure and the text code used to return the Week Number of a "Given Date".
/** D5900007
* TYPEDEF for Data Structure
* D5900007 : Get Week of the Year from Calendar date
typedef struct tagDSD5900007
{
JDEDATE jdDate;
JCHAR szBranch[13];
int nWeekNumber;
} DSD5900007 , *LPDSD5900007;
#define IDERRjdDate_1 1L
#define IDERRszBranch_2 2L
#define IDERRnWeekNumber_3 3L
#endif /* DATASTRUCTURE_D5900007 */
Listing of ER for Named ER: N5900007
=======================================================================
NAMED ER: Get Week of the Year from Calendar date
=======================================================================
evt_jdFirstDayOfYear_Date01
evt_mnDayOfWeek1st_INT01
evt_cDayType_EV01
evt_mnWeekNumber_INT01
evt_mnDayNumber_INT01
OPT: Using Defaults
0001 //
0002 VA evt_cDayType_EV01 = " "
0003 VA evt_jdFirstDayOfYear_Date01 = " "
0004 VA evt_mnDayNumber_INT01 = " "
0005 VA evt_mnDayOfWeek1st_INT01 = " "
0006 VA evt_mnWeekNumber_INT01 = ""
0007 //
0008 // Calculate the week number of the year from a given date.
0009 //
0010 VA evt_jdFirstDayOfYear_Date01 = add_months([BF jdDate],(date_month([BF jdDate])*-1))
0011 VA evt_jdFirstDayOfYear_Date01 = add_days(last_day([VA evt_jdFirstDayOfYear_Date01]),1)
0012 //
0013 F0007 Get Day of the Week
BF szBranch -> BF szBranch
VA evt_jdFirstDayOfYear_Date01 -> BF jdDate
VA evt_mnDayOfWeek1st_INT01 <- BF nDayOfWeek
VA evt_cDayType_EV01 <- BF cTypeOfDay
0014 //
0015 If VA evt_mnDayOfWeek1st_INT01 is equal to
0016 VA evt_mnDayOfWeek1st_INT01 = "7"
0017 End If
0018 //
0019 F0007 Get Day of the Week
BF szBranch -> BF szBranch
BF jdDate -> BF jdDate
VA evt_mnDayNumber_INT01 <- BF nDayOfWeek
VA evt_cDayType_EV01 <- BF cTypeOfDay
0020 //
0021 If VA evt_mnDayNumber_INT01 is equal to
0022 VA evt_mnDayNumber_INT01 = "7"
0023 End If
0024 //
0025 VA evt_mnWeekNumber_INT01 = days_between([VA evt_jdFirstDayOfYear_Date01],[BF jdDate])
0026 VA evt_mnWeekNumber_INT01 = ([VA evt_mnWeekNumber_INT01]+[VA evt_mnDayOfWeek1st_INT01])+(6-[VA evt_mnDayNumber_INT01])
0027 VA evt_mnWeekNumber_INT01 = [VA evt_mnWeekNumber_INT01]/7
0028 BF nWeekNumber = VA evt_mnWeekNumber_INT01
Friday March 25, 2016 10:31
Have a question about JD Edwards Business Functions, please contact us at inquiries@GetGSI.com