I thought I used this piece of code successfully in a Filemaker 8.5 script, but I can't seem to get it to work in Filemaker 9.

I'm trying to flag records as being new (imported into the database that day).

If [Get (CurrentTime) = assets:creation_date]

Set Field [assets::status; "NEW"]

Else

Set Field [assets::status; ""]

End If

Where assets is the table with my records and creation_date is the record creation date.

I hit run and nothing happens. Any help would be appreciated.

--jon

Welcome to the forum.

If [Get (CurrentTime) = assets:creation_date]

Set Field [assets::status; "NEW"]

Else

Set Field [assets::status; ""]

End If

Don't you want:

If (assets:creation_date = Get ([color:red]CurrentDate)

Set Field [assets::status; "NEW"]

Else

Set Field [assets::status; ""]

End If

?

Edited November 4, 200817 yr by Guest

You could also make the status field an unstored calculation, and eliminate the flagging process (which is always problematic in a multi-user scenario) altogether.

Worked like a charm.

Many thanks.