Find based on mismatched dates

[Matt Leach]

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

[comment]

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.

[Matt Leach]

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