← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] FW: d2: daysbetween AND d2:yearsbetween not working properly in 2.27 build revision b6e8cde

 

Hi there Georgi!
The expression
d2:yearsBetween(A{Date of Birth}, V{ enrollment _date})  <18
should be the correct one. I would change the V{ enrollment _date} to V{enrollment _date}

Note that before the birth date is not entered, the expression will evaluate to 0 - which will be less than 18.

Let me know how it goes.

Markus

> 9. aug. 2017 kl. 00.41 skrev Georgi Chakarov <georgi@xxxxxxxxxxxxxxxxxxx>:
> 
> Hello all! Any thoughts on my email below from last week?
>  
> Thanks,
>  
> Georgi
>  
> From: Georgi Chakarov 
> Sent: Friday, August 4, 2017 1:01 PM
> To: DHIS Users <dhis2-users@xxxxxxxxxxxxxxxxxxx>; DHIS 2 Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> Cc: Sara Gaudon <sara@xxxxxxxxxxxxxxxxxxx>; Kristiyan Panayotov <Kristiyan@xxxxxxxxxxxxxxxxxxx>
> Subject: d2: daysbetween AND d2:yearsbetween not working properly in 2.27 build revision b6e8cde
>  
> Hello all!
>  
> I am trying to create a program rule based on Date of birth and Enrollment date. Basically, I want to hide one set of data elements if the client is below 18 years old and another set of data elements if the client is above 18 years of age.
>  
> This is what I tried:
> 1)      (d2:daysBetween(A{Date of Birth}, V{enrollment_date})/365)  <18             THIS DOES NOT WORK
> 2)      (d2:yearsBetween(A{Date of Birth}, V{ enrollment _date})/365)  <18          This actually works(hides the data element I want), but I don’t think it is the correct expression.
> 3)      d2:yearsBetween(A{Date of Birth}, V{ enrollment _date})  <18                      I think that this is the correct expression, but it is executing the rule (does not hide the data element).
>  
> Do you think that there might be a bug in how these expressions work? If not, can someone guide me to the correct expression?
>  
> Thanks in advance,
>  
> Georgi
>  
>  
>  
>  
>   
> Georgi Chakarov, CIA | georgi@xxxxxxxxxxxxxxxxxxx <mailto:georgi@xxxxxxxxxxxxxxxxxxx> | +1-647-478-5634 x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 | You may unsubscribe from receiving commercial electronic messages from LogicalOutcomes by emailing info@xxxxxxxxxxxxxxxxxxx <mailto:info@xxxxxxxxxxxxxxxxxxx>
>  
> _______________________________________________
> 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