Reporting with Program Indicators (Date data element)

Hi,

We have a HIV tracker, and we want a program indicator to count the patients who Initiated Antiretroviral Therapy Within 6 Months of HIV Diagnosis (we have two fields: HIV diagnosis date and ART initiation date). We came across clues below, but we would like to have a full understanding of how we should get a program indicator working to get the correct output.

d2:daysBetween(V{analytics_period_start}, Date DE})… && d2:daysBetween(Date DE}, V{analytics_period_end})…

Could you explain what the above means?

Thanks

Hi @hernandezmachava

Why not use the d2:monthsBetween and set that the months between the first event “ART” and the second “HIV Diagnosis” should be greater than 0 months and less than 7 months in the filter.

I recommend checking out the Training Guide (Learner's Guide to Program Indicators - DHIS2 Documentation).You could also benefit from the following video:
https://www.youtube.com/watch?v=TFQUx-2l0Ks&list=PLo6Seh-066Rwew5Dh50otwA0__hCDYdwQ&index=20&t=1s

I asked the AI in docs.dhis2.org and it provided the following response :blush::

The expression d2:daysBetween(V{analytics_period_start}, Date DE})… && d2:daysBetween(Date DE}, V{analytics_period_end})… is using the d2:daysBetween function of DHIS2, which calculates the number of days between two dates.

In this case, it’s being used twice in a logical AND (&&) operation. The first part d2:daysBetween(V{analytics_period_start}, Date DE}) is calculating the number of days between the start of the analytics period (V{analytics_period_start}) and a certain date (Date DE).

The second part d2:daysBetween(Date DE}, V{analytics_period_end}) is calculating the number of days between the same date (Date DE) and the end of the analytics period (V{analytics_period_end}).

The entire expression will evaluate to true only if both parts are true. That is, the date (Date DE) falls within the analytics period (from V{analytics_period_start} to V{analytics_period_end}).

Please note that Date DE seems to represent a date data element, but without the specific context or the actual data element ID, I can’t provide more specific information.

Please keep us updated how you proceed or if you have more questions about the explanation in the training or the AI response. Thanks!

1 Like