Hi All,
What's the best way to do a fuzzy match on dates plus a description category?
I'm looking to see if there have been errors in the data entry process. For example the actual data that shoould have been input is Date: 06/05/2020, Description: Fell off Ladder. So i'm looking to identify cases such as where the following might have happened:
1. Date: 05/06/2020 Description: Fell off Ladder
2. Date: 06/06/2020 Description: Fell off Ladder
3. Date: 06/05/2002 Description: Fell off Ladder
I have been able to find fuzzy matchs if the "Fell off Ladder" part was slightly different, but am struggling to find the best way for dates.
Can anybody help?
Thanks,
Pete
