My database stores all of the notes for a record in a separate table from the record.

In this table, there are 2 fields that record the date the note was created:

Date_Created - AutoEnter Creation Date, prohibit Modification

TimeStamp_Creation - AutoEnter Creation Timestamp

The TimeStamp_Creation field is displayed on the note along with a text entry box for their note. We have purposely left the TimeStamp_Creation field modifiable to see who is actually changing the dates (which we were unable to do in our last system).

What i would like to do is create a report to show those notes which have been changed, but i am having issues with how to perform the find.

I've setup a script to go to the layout for the report and do a quick find based on the following:

SalesNotes::Date_Created  ≠  GetAsDate ( SalesNotes::TimeStamp_Creation )

i've also tried:

SalesNotes::Date_Created  ≠  LeftWords ( SalesNotes::TimeStamp_Creation ; 1 )

This searches some records that do not match, but it also includes records that do match and i know for a fact that it is leaving some out.

What would be the best way to search for this accurately?

Thanks

You cannot perform calculations during find. To find notes that have had their timestamp field modified, define a calculation field (result is Number) =

Date_Created  ≠  GetAsDate ( TimeStamp_Creation )

and search for 1 in this field.

You cannot perform calculations during find. To find notes that have had their timestamp field modified, define a calculation field (result is Number) =

Date_Created  ≠  GetAsDate ( TimeStamp_Creation )

and search for 1 in this field.

Thank you for the prompt reply. I was thinking i may need to do something along those lines. Just implemented and it worked as needed

Thanks again