Current Month - Expression Builder

[#1]

Hi,

Can someone help me please, I want to bring back some filtered data via expression builder for the current months data.  Currently I have the following expression which gives me records for the current day, how do I ammend this for everything within the current month?

=SUM(if([TableOpening.Date Instructions Received]=(Today()),1,0))

I will then want to expand that to quarters if possible?

Thanks in advance

[jonathandienst · Accepted solution]

Hi

Several ways, one being:

=SUM(if(MonthStart([TableOpening.Date Instructions Received])=MonthStart(Today()),1,0))

Hope that helps

Jonathan

[#3]

Thanks Jonathan,

Any suggestions on how best to approach the quarters scenario?

[jonathandienst]

You can use QuarterStart() in the same way

Jonathan