Jocul

Thanks comment That worked..

Tried that but I get an error when I try to exit the calculation area.. An Operator (e.g. +,-,*,...) is expected here. So it seems to need it. any other ideas?

Ok I give up.... I've searched the forums up and down and still can't can get it. My Script is: Enter Find Mode[] Set Field[Adress Book::ExportDate; "<=" & Address Book::CreationDate] [color:purple]{I've tried switching the field names around also} Perform Find [] All I'm trying to do is find all records created (i.e. field name-CreationDate) after the last date I exported the records(i.e. field name-ExportDate) But when I run it I get the prompt that no records meet the criteria message. When I run the scripted editor the field is empty I don't understand why? I've seen this type of format in many examples that are posted. Before any one asks, yes both field are of type date. If I take out the reference to the second field and replace with a date (i.e. "01/01/2006") it works ok So what I'm I missing. Thanks for the help in advance...

Just to add, I never noticed the fuzzy fonts in early versions. Also I find that even using the darkest setting the characters are more grey than black. And the last point(vent). Is I don't understand how come the fonts are fuzzy but if you have a drop down in the field the list in the drop down is nice and clear!! aarrgghhh!

Yes I'm in the same boat. It looks like with v7 it seems to make more sense to rebuild as to take full advantage of the new features. I guess I'm more concerned with the bugs in v7 itself.

Ok? I'm looking at upgrading from v6 to 7..... SO SHOULD I? Not sure what to do?

Sorry for the confusion. Thanks Queue, that was what I was looking for. Works like a charm.

True that works for sorting the records on Modified date. But what I'm after is it to sort on the date entered in the date field. When you move ahead or back it is the next record based on the date in the date field. For Example: I have these records already in the database sorted on the date entered into the date field 12/02/2003 12/04/2003 12/05/2003 12/06/2003 I now enter a record 12/03/2003 in the date field. Once I hit the save button I want the records showing like this. 12/02/2003 12/03/2003 <-- with this record up on the screen 12/04/2003 12/05/2003 12/06/2003

True this will work if the recorded added is the latest date. But the record added could be any date..so the record I need to display maybe in any position in the database.

This must be simple, but I just can't figure it out. All I want to do is show the last touched record (new or edited) and list all records sorted in order. Let me explain: I've added a button (save) which runs a script. In this script I want to save the current record then sort all records in the database on a date field and then display all records sorted by date with the last touched record showing. I can find the correct record using a flag [could not get status(currentrecordid) to get me to the correct record] or I can sort all records based on the date field. But I can't seem to get both at the same time. Any help would be greatly appreciated.. thanks in advance.