Hi you all....

First my question, then the story behind it:

How can i find modified records based upon timestamp? Find: > 6/15/2005 1:33:57 PM does not work.

This is what i did (all to bypass the purchase of FM Server Advanced for a ODBC connection):

I have a "mother" DB. I extract data from that into a "child" and distribute the child to 3 workstations(Macs) where they become a local ODBC source. This child source reveived a import timestamp. After that the child-odbc sources get update through ODBC from within Indesign. Next step is to bring the data back from the child to the mother. Therefore i need to indentify which records got modified: all after the initial import timestamp. Fields now created: import timestamp and modified timestamp. Search has to be: all later than importimestamp.

Any ideas are welcome.

Greetings ,

Marcel.

I have used find in the way suggested on a timestamp field and it works OK, so you should investigate why the find is not working. I think it is the PM. Try the same search with 13 in the hours and no PM.

Some additonal question: can i use a timestamp WITHOUT seconds?: This would solve my problem..

Cheers,

Marcel

did you try formattiong the time field to display hh:mm instead of hh:mm:ss?

No. FMP7 is very rigid about timestamp format. If you want more flexibility you may have to split the timestamp into a date and a time. There is more flexibility in finding times.

Well....using the timestamp looks nice BUT the formating changes when a field in entered/clicked. Obviously i used the time format to only show hours and minutes but the re-appear when i enter the field. I have a VERY weird way of setting a find-field: copy-paste steps: i copy the import-time and paste it in the modification-time. Perform a search, show omitted shows me the changed records since last import: should work i guess. So thing is to search date, hour and minute: NOT seconds because within the import-time there are 2-4 seconds.

How are you entering the find criteria? If you script the process like:

Enter Find Mode [ ]

Set Field [ Table::modifiedTimeStamp ; ">" & Table::importTimeStamp ]

Perform Find [ ]

it should work.

I just don't get it...AAAArrghhhhhhh.....I used the script from above (oldhand...thx) but it does NOT work...the Set field step does NOT work so obviously nothing is found. When I search this: > 20-06-2005 11:15:26 to find this 20-06-2005 11:31 it does not work!!! What's wrong? Both fields are timestamps.

Greetings,

MacB

It's hard to say what's wrong when all you say is "it does not work!!!"...

Guessing: importTimeStamp must be a global field, otherwise you cannot refer to it in Find mode. If importTimeStamp cannot be a global field, try changing the script to:

Enter Find Mode [ ]

Set Field [ Table::modifiedTimeStamp ; ">" & Get (ScriptParameter) ]

Perform Find [ ]

Then attach the script to a button, and in the button definitions define script parameter = importTimeStamp.

To see what's happening, insert a pause before Perform Find.

Yeah..sorry mate.... but i've trying very very hard to get this final step in a workflow going.

What's not working is the find request (by script or manual) Searching a date later as set does not give any result...;-(

Can you attach a sample file that demonstrates the problem?