Re: [Dhis2-users] Program Indicator calculations, Converting Dates in Months or Years

2016-11-04 Thread Muhire Andrew
Thanks Prosper and team, This is helpful too. On Friday, November 4, 2016 1:59 PM, Prosper BT wrote: Hi Andrew,See this related emails from Markus .The d2:yearsBetween() is not yet supported in the server side aggregation of program indicators. For now you would have to use d2:days

Re: [Dhis2-users] Program Indicator calculations, Converting Dates in Months or Years

2016-11-04 Thread Muhire Andrew
Thanks Alex, This is helpful. On Friday, November 4, 2016 2:10 PM, Alex Tumwesigye wrote: Dear Andrew, You can use (V{current_date} - A{Date of Birth UID})/30 to estimate months or (V{current_date} - A{Date of Birth UID})/365 to get estimate years. Alex On Fri, Nov 4, 2016 at 3:06 PM,

Re: [Dhis2-users] Program Indicator calculations, Converting Dates in Months or Years

2016-11-04 Thread Lars Helge Øverland
Hi Andrew, thanks that looks good. On Fri, Nov 4, 2016 at 2:59 PM, Muhire Andrew wrote: > Thanks Lars, > > I came to find an expression in indicators that does this in tracker: > > like 40 - d2:weeksBetween(mother visit LMP, Current date) > > *The above gives the count down of the weeks remainin

Re: [Dhis2-users] Program Indicator calculations, Converting Dates in Months or Years

2016-11-04 Thread Muhire Andrew
Thanks Lars, I came to find an expression in indicators that does this in tracker: like 40 - d2:weeksBetween(mother visit LMP, Current date) The above gives the count down of the weeks remaining for the mother to deliver since the delivery has approximately 40 weeks. Another expression was to disp

Re: [Dhis2-users] Program Indicator calculations, Converting Dates in Months or Years

2016-11-04 Thread Alex Tumwesigye
Dear Andrew, You can use (V{current_date} - A{Date of Birth UID})/30 to estimate months or (V{current_date} - A{Date of Birth UID})/365 to get estimate years. Alex On Fri, Nov 4, 2016 at 3:06 PM, Alex Tumwesigye wrote: > Dear Andrew, > > You can use (current_date - Date of Birth)/30 to estimat

Re: [Dhis2-users] Program Indicator calculations, Converting Dates in Months or Years

2016-11-04 Thread Alex Tumwesigye
Dear Andrew, You can use (current_date - Date of Birth)/30 to estimate months or (current_date - Date of Birth)/365 to get estimate years. Alex On Fri, Nov 4, 2016 at 2:52 PM, Lars Helge Øverland wrote: > Hi Andrew, > > how are you doing? First of all, would you mind asking this on the dev > l

Re: [Dhis2-users] Program Indicator calculations, Converting Dates in Months or Years

2016-11-04 Thread Prosper BT
Hi Andrew, See this related emails from Markus . The d2:yearsBetween() is not yet supported in the server side aggregation of program indicators. For now you would have to use d2:daysBetween() / 365 - which is not 100% correct as the leap years is not considered. You wrote d2daysBetween in yo

Re: [Dhis2-users] Program Indicator calculations, Converting Dates in Months or Years

2016-11-04 Thread Lars Helge Øverland
Hi Andrew, how are you doing? First of all, would you mind asking this on the dev list? There are more people who can help you there. Also it would be good if you could elaborate a bit about what you need to do regarding date conversion. Is the problem that you are asking beneficiaries about thei

[Dhis2-users] Program Indicator calculations, Converting Dates in Months or Years

2016-10-28 Thread Muhire Andrew
Dear All, We are developing the case based nutrition system [Using DHIS2] that is targeting to track Pregnant Women, Lactating and Children under 2years.What we are tracking is Attributes and tracker variables like Date of Birth, hight, weight, LMP Date and We would like to Display on our progra