query-fc76e5349d989b54e05584c992352eda

rq turtle/ttl

Inverted DOB day and month 14:30, 18 November 2019 (UTC)) talk (Steak). In such cases, it is highly likely that one of the two dates was created by erroneously inverting day and month. (Q706518)B. J. Thomas I am wondering if it is possible to systematically query all cases where there are two DOBs, with one beeing "X-Y-year" and one "Y-X-year" (example: Interesting idea. Here we go:

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT *
{
    # BIND(wd:Q706518 as ?item) 
    ?item wdt:P214 [] .
    ?item wdt:P569 ?d1 ; wdt:P569 ?d2 .
    FILTER( 
          ?d1 != ?d2 
           && MONTH(?d1) = DAY(?d2) 
           && DAY(?d1) = MONTH(?d2) 
           && YEAR(?d1) = YEAR(?d2) 
           && DAY(?d1) != DAY(?d2) 
          )
}
LIMIT 10

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?d1"):::projected v2("?d2"):::projected v3("?item"):::projected a1((" ")) f0[["?d1 != ?d2month-from-dateTime(?d1) = day-from-dateTime(?d2)day-from-dateTime(?d1) = month-from-dateTime(?d2)year-from-dateTime(?d1) = year-from-dateTime(?d2)day-from-dateTime(?d1) != day-from-dateTime(?d2)"]] f0 --> v1 f0 --> v2 v3 --"wdt:P214"--> a1 v3 --"wdt:P569"--> v1 v3 --"wdt:P569"--> v2