Forum Discussion
Power Query Date Filter missing dates
I am in charge of tracking a covid check-in database for my org, and I have a spreadsheet that has been working for weeks. It's now failing on 2 fronts, and I can't see why at all. The check-ins...
The problem is MS forms does not have data validation so anyone can enter text with leading or trailing spaces, check for that using SUBSTITUTE and TRIM Functions