AnsweredAssumed Answered

Finding the last 6 months (or last 12)

Question asked by MartinLange on Jan 6, 2014
Latest reply on Jan 6, 2014 by MartinLange


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.