83
edits
Excel Data Quality Toolkit: Difference between revisions
→Date Hasn't Happened Yet
Jegelewicz (talk | contribs) |
Jegelewicz (talk | contribs) |
||
| Line 29: | Line 29: | ||
'''Problem:''' The date the specimen was [https://dwc.tdwg.org/terms/#dwc:dateIdentified identified], collected (often designated using the [https://dwc.tdwg.org/terms/#dwc:eventDate eventDate] field), or [https://dwc.tdwg.org/terms/#dwc:georeferencedDate georeferenced] is in the future. | '''Problem:''' The date the specimen was [https://dwc.tdwg.org/terms/#dwc:dateIdentified identified], collected (often designated using the [https://dwc.tdwg.org/terms/#dwc:eventDate eventDate] field), or [https://dwc.tdwg.org/terms/#dwc:georeferencedDate georeferenced] is in the future. | ||
'''Solution:''' Check that dates are before today with this formula. =IF(A1>TODAY(),"ERROR","OK") | '''Solution:''' Check that dates are before today with this formula where A1 is the date you want to test. | ||
=IF(A1>TODAY(),"ERROR","OK") | |||
=== Date is Suspiciously Old === | === Date is Suspiciously Old === | ||