Expression dates

[bratman93]

Hi everyone!

I have this expression

 =sum( If(Date>=MonthStart(Today(),-1) and Date<MonthStart(Today()) ,ErrandCounter))

which gives me the number of errands created the previous month. How do I change it so that it gives me number of errands current month?

[Mark_Little]

Hi

sum( If(Date>=MonthStart(Today()) and Date<Today() ,ErrandCounter))

Should work

[bratman93]

BIG THANKS

[jonas_rezende]

Hi, @bratman93 .

Please, try:

Sum({<Date = {">=$(=MonthStart(Today(1)))"}>} ErrandCounter)

I hope this helps!