Automatic Calculation of EPI week, month and day

[Gassim (AL-Gassim Sharaf Addin)]

Hi @Gerald_Thomas!
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’:

How to get Month in event_date variable

Hi @didate, I’ve just tried it with the last android version (2.4.1) and it is working fine. This is the expression I’ve used: d2:right(d2:left(V{current_date},7),2) V{current_date} will return a date with the following format: yyyy-MM-dd. So the inner d2:left will return the first 7 characters from the left yyyy-MM and then the d2:right will return just MM which is what you are trying to achieve.

Hope it helps!

Please feel free to post back!