Return the last day of the current month
Posted: Thu Jul 30, 2015 2:12 pm
Hi All,
I am new to this forum and i need some help. I am trying to create a SumIf function if one data in my data band is greater than the last day of the current month. If it is true then return a secific data, if false return 0.
Finally, in my groupfooter, I want to calculate the sum of this sumif funtion.
Any help or guidance to achieve that would be grateful!
Thanks in advance.
Nico
I am new to this forum and i need some help. I am trying to create a SumIf function if one data in my data band is greater than the last day of the current month. If it is true then return a secific data, if false return 0.
Finally, in my groupfooter, I want to calculate the sum of this sumif funtion.
Any help or guidance to achieve that would be grateful!
Thanks in advance.
Nico