I'm trying to add invoice values for individual months. I have created a field using a if statement and getasdate If (Date = GetAsDate("4/2008"); Value ; 0 )
and a summary field to display the total.
However it doesnt work, I think because the format of date field is dd/mm/yyyy. Have tried wildcards ** in place of dd still no luck.
is there some way round this or a better way of doing this.