AnsweredAssumed Answered

Searching by Fiscal Year

Question asked by Atkins on Oct 30, 2012
Latest reply on Oct 31, 2012 by Atkins


Searching by Fiscal Year



     I'm trying to create a report that searches by fiscal year and shows items that have a date in that range.  The "date" field is a calculation field based on other fields related to the record, and it's working well.  Because I'm searching by fiscal year, I know the beginning and end dates, and I want the user to give a single input as to what fiscal year they want to search.

     For instance:  I have a pop-up that asks, "what fiscal year would you like to search?" and prompt them to put in a 4-digit year.  If they input 2012 then I want to search the date range for 9/1/2012 to 8/31/2013.  I've tried several different iteration of calculations and scripts to try and make this work and am just not having any luck.  I also read a post that said to use a 'set field' script and put in a date range using the "..." operator, but I can't set the field I want to search because it's a calculation field and is not editable.  Maybe this is the root of my problem?

     Any feedback would be appreciated.  I think I need help with the logic as much as the actual scripting.  How do I get a year entry (2012) into a date range of 9/1/2012 to 8/31/2012 in my script?  And then how do I search my records using that info?