Hi all,
I have a customized program indicator, which takes the data element (DATE) and makes the respective sum. But for some reason the data element even with the data type Date is allowing values such as DATE & TIME, this causes the indicator to end up being aggregated in the wrong way, since if the data element '2021-05-14 00: 00: 58.414 'ends up being counted on the 15th instead of the 14th.
Any help is welcome
Hey @asacur !
Based on the setup above, the indicator should count the enrollment on the 14th, even when there is some dates saved with the extra time in your data. This seems like a bug that should be investigated.
There might be a workaround that you can try in the meantime.
Change your end boundary slightly; Change it from “Before end of reporting period” and set it to “Before start of reporting period”, and select offset period by amount to “1”, and select “Days” in Period type.