Jump to content

  •  

Photo

date search scripts


  • Please log in to reply
1 reply to this topic

#1 Bbuwell  newbie

Bbuwell
  • 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

Today
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


Thanks...

Brian

bburwell@gmail.com
  • 0

#2 Lee Smith  I like the v13 layout tools

Lee Smith
  • Staff
  • 10,204 posts
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch
  • Platform:Mac OS X Mavericks
  • Skill Level:Expert
  • Membership:TechNet
  • Time Online: 235d 19h 10m 34s

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