dhis2-users team mailing list archive

[Tran Chau <tran.hispvietnam@xxxxxxxxx>]

Hi Channara,

There are four kinds of datediff formulas supported :

*1.* Incident date diff : Get the number of days between a data element and
incident-date of tracked entity instance ( TEI ). Below is an example for
this case :
* DATEDIFF([DE:1.2.3] , dateOfIncident)  > 1*

*2.* Enrollment date diff : Get the number of days between a data element
and enrollment-date of tracked entity instance ( TEI ). Below is an example
for this case :
* DATEDIFF([DE:1.2**.3**] , enrollmentDate)  > 1*

*3. *Report date diff : Get the number of days between a data element and a
report-date of an event of tracked entity instance ( TEI ). Below is an
example for this case :
* DATEDIFF([DE:1.2**.3**] , executionDate)  > 1*

*4. *Data element date diff : Get the number of days between a data element
and a report-date of an event of tracked entity instance ( TEI ). Below is
an example for this case :
* DATEDIFF([DE:1.2**.3**] , [DE:1.2.4])  > 1*

The formulas to calculate the number of days related to DATE attributes
haven't supported yet.


Best regards,
------------------------------------------------
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@xxxxxxxxx


On Tue, Jul 22, 2014 at 10:54 PM, <rin.channara@xxxxxxxxx> wrote:

>  HI all users,
> anyone know how to use datediff in aggregate builder. I try many time with
> datediff function in aggregate builder. when I click test, I got the
> alert “warning message”. do you know why?
> I use datediff to calculate many day of date of birth with date of
> enrollment.
>
> thank you
> channara
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>