I'm formatting a report to highlight certain lines (eg if this & this apply, then turn the line red etc).
I have a date field "milestone due", and I need to highlight milestones due this month. Previously, for other things, I've used "Now - 31" to give anything falling within the last month; but this is actually the calendar month. ie, if its the June report, I need to highlight 1/6 to 30/6; but the report could be finished at any time in July. (And sometimes even run over into August).
Because of how the data is compiled (bit complicated to go into), there is no report month field available.
I have a date field "milestone due", and I need to highlight milestones due this month. Previously, for other things, I've used "Now - 31" to give anything falling within the last month; but this is actually the calendar month. ie, if its the June report, I need to highlight 1/6 to 30/6; but the report could be finished at any time in July. (And sometimes even run over into August).
Because of how the data is compiled (bit complicated to go into), there is no report month field available.
