Date Problem

[Devin]

I'm trying to write a script that:

enters Find Mode

Does a Set field on Field "Date" from a gobal field "gobaldate"

I then want it to find all dates that are greaterthan "gobaldate"

So I thought on the set field script I could put

"> " & gobaldate

But since it's a date field it will not allow any thing other than a date. If I make my date fileds text it works but I wan't to view my fields as dates (11/16/00).

Is there a work around for this problem?

Thanks Devin

[Chuck]

Make sure that the field you are searching on is on the layout you are in during the script, perhaps using a Go to Layout script step, and then use the Insert Calculated Result script step instead of Set Field.

Chuck

[Devin]

I was using a goto layout

I tried the insert cal and got some wierd numbers.

The Cal field reads:

">" & gobaldate

Devin

[LiveOak]

This is one of those operation that has been goofy in FM from the start. I created at test file. The first time I tried it (FM5 & Mac) it worked, then it quit working - wierd. Try instead:

Define gTextDate (global, text)

SetField[gTextDate, ">"& gobaldate

Enter Find Mode []

Copy [select, "gTextDate"]

Paste["Date"]

Perform Find []

I'm not sure why you have to do this and date ranges in such a round about manner. It's strange that the Insert Calculated Result fails. -bd

[Devin]

that worked great

thanks

Devin