Hi everyone,
Following instructions from a popular power apps book for saving dates in year-month-day format. According to the PowerApps book the following should work provided my source excel column is formatted as text. this is what is in the
DateTimeValue(Left(Parent.Default, 4) & "-" & Mid(Parent.Default, 5,2) & "-" & Mid(Parent.Default, 7,2) & " "& Mid(Parent.Default,9,2) & ":" & Mid(Parent.Default,11,2))
I have followed all the directions and still no joy, it's complaining that it is expecting text in the left & mid functions. Any help is appreciated! Attached is a screen shot and excel file.