Sign in to follow this  
Followers 0

date search scripts

2 posts in this topic

Posted

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

Share this post


Link to post
Share on other sites

Posted

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0