dhis2-users team mailing list archive

[<rin.channara@xxxxxxxxx>]

thank you. I understand,

but I would to confirm with you that the attribute with date type is not support for calculate in aggregate builder?

if SO, when they will plan implement it?





From: Tran Chau
Sent: ‎Wednesday‎, ‎July‎ ‎23‎, ‎2014 ‎10‎:‎57‎ ‎Morning
To: channara rin
Cc: DHIS 2 Users list





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