formula issue

samuel_brierley — Tue, 21 Jan 2014 09:16:06 GMT

Hi I have the follwing formula, admittedly the community helped me with it,

however I need it to do the same thing but instead of being before today it needs to be before the first day of the month?

sum({$< Date = {'>$(=Today())'}>} [Forecast Hours])

Re: formula issue

Sokkorn — Tue, 21 Jan 2014 09:18:55 GMT

sum({$< Date = {'>$(=MonthStart(Today()))'}>} [Forecast Hours])