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
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.
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com
On Tue, Jul 22, 2014 at 10:54 PM, rin.channara@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
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?
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com
On Tue, Jul 22, 2014 at 10:54 PM, rin.channara@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
No, the DATE attributes haven’t supported in aggregate builder. I sent email to Oslo to discuss about supporting it for version 2.17.
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com
On Wed, Jul 23, 2014 at 11:05 AM, rin.channara@gmail.com wrote:
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.
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com
On Tue, Jul 22, 2014 at 10:54 PM, rin.channara@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp