Jump to content



date search scripts

  • Please log in to reply
1 reply to this topic

#1 Bbuwell  newbie

  • Newbies
  • PipPipPipPip
  • 4 posts
  • FM Application:11
  • Platform:Mac OS X Lion
  • Skill Level:Beginner

Posted 26 January 2012 - 09:00 PM

I would like to make my report have a drop down menu that will select records from

Last week
Last month
6 month to today
1 year to today
last year

I am completely unsure how to do this. I am assuming there must be a script needed. In my database the dates are for when the invoice was charged/billed. No other dates to speak of.

Would someone mind walking me through this please ?

I know how to make buttons, and get them to run a script. But I don't know where to begin with the script to make the desired output / result



  • 0

#2 Lee Smith  I like the v13 layout tools

Lee Smith
  • Staff
  • 10,517 posts
  • LocationWoodland, CA
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch, iPad
  • Platform:Mac OS X Yosemite
  • Skill Level:Expert
  • Membership:TechNet
  • Time Online: 257d 12h 20m 54s

Posted 26 January 2012 - 10:45 PM

See if this helps. http://fmforums.com/...post__p__380588

Note: the calculation does not have to be Custom Function. Just create a new field with a calculation results of text, and paste it right in.
  • 0

FMForum Advertisers