← Back to team overview

dhis2-users team mailing list archive

Re: 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:
https://www.dhis2.org/contact

For aggregation of events I suggest you have a look at the Program
Indicators, documented here:
http://dhis2.github.io/dhis2-docs/master/en/user/html/ch30.html

Including functions like daysBetween documented here:
http://dhis2.github.io/dhis2-docs/master/en/user/html/ch30s03.html#d5e7283


Ola
-----

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

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
<https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norge&hl=en&ie=UTF8&sll=59.893855,10.785116&sspn=0.222842,0.585709&oq=eftas%C3%A5sen+68,+0687+Oslo,+&t=h&hnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norway&z=16>

On 25 February 2016 at 10:59, Pavel Kozlov <pavel@xxxxxxxxx> 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