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: [email protected] On Tue, Jul 22, 2014 at 10:54 PM, <[email protected]> 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 : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
