I am creating a Maternal Death Surveillance Reporting (MDSR) form. I want the EPI week, month and day to be automatically calculated once the "Date Death Occurred" is entered. Please can some help with the procedure?
Attached is a screenshot of what I want to achieve.
This is a very interesting question and I thought it would be simple but I can’t find a function in program rules that will change the static version of the date ‘yyyy-MM-dd’ to ‘yyyy’ or ‘Year’ … etc Assuming it is possible to get to the result using the ‘date between’ functions, it seems too complicated to even try!
I need to ask if there is a function such as DATE_PART(), EXTRACT (MONTH,date), or as simple as MONTH(date).
UPDATE: Reading through the CoP posts, I found this which should help with creating the program rules that will assign the values based on the date in the ‘Date Death Occurred’:
Hope it helps!
Please feel free to post back!