Finding the last 6 months (or last 12)
I have been reading the forum and searching the FMP help section, but can't seem to find an answer to my question, so I'm posting it here.
I am trying to write a script that allows me to find the last six months of donations our organization has received.
I've been using "Insert Calculated Result [Select; Donations::Date Given; Get (CurrentDate) - 180 & "…" & Get (CurrentDate)]
But I don't want to use days, I want the search to return months. ie. If this is January, I want to see the donations from July 1 - Dec 31
Any help would be appreciated.