← Back to team overview

dhis2-users team mailing list archive

Re: aggregate builder

 

No, the DATE attributes haven't supported in aggregate builder. I sent
email to Oslo to discuss about supporting it for version 2.17.

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


On Wed, Jul 23, 2014 at 11:05 AM, <rin.channara@xxxxxxxxx> 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 <tran.hispvietnam@xxxxxxxxx>
> *Sent:* ‎Wednesday‎, ‎July‎ ‎23‎, ‎2014 ‎10‎:‎57‎ ‎Morning
> *To:* channara rin <rin.channara@xxxxxxxxx>
> *Cc:* DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>
>
> 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
>>
>>
>

References