learnernames is a table of names, codes, etc about 27 columns long. Unfortunately when I started this project I forgot to put a name to the columns, regretting now but already coded in lots of palces to change them.
Column1 is a list of names with all spaces taken out and lowercase so "Fred Bloggs" is "fredbloggs"
thestrippedname_2 is lowercase no spaces so could be "fredbloggs" this is created by selecting a record from a gallery on the same screen.
Column12 is the column I want to store the data stored in patchstartdate which is a date column on excel and is entered on powerapps via date picker
I am convinced the problem is the formatting of the date, but I just can not work it out. I have tried changing it to a string and changin gthe date into different formats.