Find me a date

[jhomer]

I have a DB which we use for attendance absences.

I am writing a simple script for a report to find records where the creation date and the modification date differ. Both Fields are set to auto enter the date and are unmodifiable.

For some reason FM will not allow me to compare these two fields.

Am I just missing something? again any help would be appreciated.

[RalphL]

Make a number calcualtion field Creation Date = Modification Date. It will return a 1 if they match and a 0 if the don't. Do your find on this field.

Or you could do it with a relationship Creation Date <> Modification Date. Go to related record Show will also give you the records where the dates differ.

[jhomer]

again thanks for the help

[comment]

Creation Date <> Modification Date

One record's Creation Date could match another record's Modification Date. Better add to that:

AND

RecordID = RecordID

[RalphL]

Good catch comment.