Date range script for a certain field

[TaiChi56]

I have a certain field that carries tax sale amount. I need to be able to go in and put in a certain start date and end date that will give me every record witin that range with the tax amount. I do not have a portal set up since I am still learning FileMaker Pro. How can I do this?

[VICH]

first you need two global fields

searchdate1

searchdate2

then you need a script

enter find mode

set field [ taxdate; searchdate1 & "..." & searchdate2]

perform find

just make sure that you input the dates in before you run the script

Edited September 9, 2005 by Guest
i accidentally but a $ in the calc when it should of been an &

[TaiChi56]

Thank you. I will give that a try.

[VICH]

i hope you noticed my edit before you did it other wise you calc won't work..i put a $ in by mistake it should be an &

[TaiChi56]

Thank you but I am still having a problem. It is giving me an error saying the specified table cannot be found. I went into scriptwriter and put in:

enter find mode

set field (here i clicked specify calculated result) and typed in date sold;search1 &"..." searchdate2

and tried to click ok, it gave me the "Cannot find the specified table" and it highlites date sold.

What am I doing wrong? Thank you.

[sbg2]

search1 & "..." & searchdate2

you are forgetting the "&" before searchdate2.

[VICH]

yea that missing & is the only problem i could imagin you having...but try this..if you typed in the field name..delete it then find it and choose it from the list of all your fields...if you have more than one table in you database you have to specify the table

set feild(table1::datesold; search1 & "..." & search2)

Edited September 13, 2005 by Guest