month start in set analysis

[samuel_brierley]

Hi all,

can someone please explain why the first formula results in the error 'Error in set modifier'

and please point me to how to correct it.

thanks in advance

=count({1<Issue_Date = {$(=MonthStart(Now()))} ,Fault_Classification = {'3'} >}Fault_Classification)

=count({1<Issue_Date = {'01/08/2015'} ,Fault_Classification = {'3'} >}Fault_Classification)

[sunny_talwar · Accepted solution]

May be try it with double quotes:

=Count({1<Issue_Date = {"$(=MonthStart(Now()))"}, Fault_Classification = {'3'} >} Fault_Classification) or

=Count({1<Issue_Date = {"$(=Date(MonthStart(Now()), 'DD/MM/YYYY'))"}, Fault_Classification = {'3'} >} Fault_Classification)

[samuel_brierley]

Yep That's got it thanks