Program Indicators: Using Event Dates in expression

Dear DHIS2 users,

I have a question regarding the use of Event Dates in Program Indicators expression:
Is there a way to specify “event_date” in expression if we have more than one events in a Program?

Example: We have a Tracker Capture Program with 3 Stages (Events). We would like to count the number of days between Stage 1 and Stage 2.

This can be done with adding data elements “Date” for each stage and then use the d2:daysBetween function. But would be nice to know how to use the event_date in expressions.

Kind Regards,
Kris

1 Like

Hi

See JIRA issue DHIS2-1397

Regards
Calle

1 Like

Thank you, Calle. I guess we’ll stick to data elements with value type date for now.
Untill the feature gets implemented.

Kris

2 Likes

Hi,

I believe this may now have been partially taken care of in 2.31:

https://jira.dhis2.org/browse/DHIS2-4748

However you may have trouble with repeated stages, as it only grabs the most recent event date within a program stage I believe.

3 Likes

Thank you Shurajit, for your response.

There is still no way to specify event date in expression if you have multiple events. Because we have deadlines - we tackled this with data elements (value type dates). Works fine with function d2:daysBetween. I will keep an eye for future updates on this topic.

2 Likes