83
edits
Excel Data Quality Toolkit: Difference between revisions
Jump to navigation
Jump to search
→Identified Date Earlier than Collected Date
Jegelewicz (talk | contribs) |
Jegelewicz (talk | contribs) |
||
| Line 46: | Line 46: | ||
'''Problem:''' The date the specimen was identified (dateIdentified field) is earlier than the date the specimen was collected (eventDate). | '''Problem:''' The date the specimen was identified (dateIdentified field) is earlier than the date the specimen was collected (eventDate). | ||
'''Solution:''' Check that collection dates are before identification dates with this formula. =IF(A1<B1,"ERROR","OK") | '''Solution:''' Check that collection dates are before identification dates with this formula where A1 is the identification date and B1 is the collection date. | ||
=IF(A1<B1,"ERROR","OK") | |||
=== Year, Month, and Day Values Do Not Match Date === | === Year, Month, and Day Values Do Not Match Date === | ||