Number of days between dates from different program stages

[ferdinandmussavene (ferdinand)]

Hi All,

I would like to know if it is possible to calculate number of days between dates in different program stages.

Example: Number of days between Admission Date(event date of stage admission) and Discharge date (event date of stage discharge).

Thanks

[Markus (Markus Bekken)]

Hi there!
Yes you can. Have a look at the reference table and see the d2:xxxBetween date functions:

Home - DHIS2 Documentation

These functions accepts a syntax that references the (latest) event date for a program stage in an enrollment:
PS_EVENTDATE:(programStageUid)
In your example:
d2:daysBetween(PS_EVENTDATE:(admisstionProgramStageUid), PS_EVENTDATE:(dischargeProgramStageUid))

Markus