DATEDIFF function in aggregated query

Hi Pavel,

I moved your question to the DHIS 2 users list, a better place for technical questions about DHIS 2.

If you haven’t signed up for the list yet, please read how to here:

For aggregation of events I suggest you have a look at the Program Indicators, documented here:

Including functions like daysBetween documented here:



On 25 February 2016 at 10:59, Pavel Kozlov wrote:

Hello experts!

I have question about DATEDIFF function in aggregated query. How it works? Or where I can read about this?

For example: DATEDIFF([data element one], [data element two]) result in days or in data set dimension?

Best regards, Pavel

Ola Hodne Titlestad (Mr)
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link