at the top of a field box ? I created a script to insert the current date but it keep putting at the end of the previous date. I need to put it before older date, pushing older date to the bottom. It is possible with filemaker ? thank for your help.

FileMaker Version: 6

Platform: Mac OS X Panther

If it's a text field, yes. Set Field [textfield, Status(CurrentDate) & "

it works really fine! thanks a lot. Could I ask you another question ?

I'm building a datebase for a call center. we've a LAST CALL and NEXT CALL field. every week, i need to produce a report showing all the call made during that week. i need to create a script that will do this search, in the LAST CALL field : >= today - 7. how could i do that ? thank for helping a newbie...

Set Error Capture [On]

Go to Layout [layout containing LAST CALL]

Enter Find Mode [ ]

Insert Calculated Result [LAST CALL, ">=" & DateToText(Status(CurrentDate) - 7 )]

Perform Find [ ]

If [not Status(CurrentFoundCount)]

Show Message ["No calls were made during the last week."]

End If

Its not working because filemaker is changing the current date to a number. is that because of the LAST CALL field is a Date format ?

You need to use DateToText the way Q described it.

Hi,

Notwithstanding Queue's method, I always prefer relationships for these kind of daily use function.

It also often solve these Insert problems and offer IMO a dynamic way to individually access matched records, as they would appear in a portal, or go to related records for a classic reports when you want to.

Create a global field gWeek (text) and a relationship from gWeek to your Last Call field (either date or text doesn't matter).

Use a portal to view these records, and make each row a button "GoToRelated records".

Then, the script.

Set Field[gWeek,

DateToText(Status(CurrentDate))&"

Fitch I did use the Datetotext as mention by Q...

tizoube said:

Fitch I did use the Datetotext as mention by Q...

Check this back then as well as the Perform Find[ ] step...

FileMaker Version: 6

Platform: Mac OS 9

Sorry guys, just found out my mistake. another question :

how to send email with the Open URL fonction ?

You're on a Mac. You should get a Send Message script step that's just designed for this.

FileMaker Version: 6

Platform: Mac OS 9

Yes Ugo and I did try it, but is doesn't open a new message window on Outlook. I tried with the Open URL and the mailto: fonction and is working fine. The only thing that I'm wondering is how to set the email address with my email field. any help ?

THANK YOU ALL...I did figure out my problem. This Forum is the BEST!