Jump to content

Find based on mismatched dates

Matt Leach

This topic is 4401 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?


Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 4401 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.