Forum Discussion
Solved
DataFormat.Error: We couldn't parse the input provided as a Date value. Details:
In PQ, initiated a New Source from a folder with a host of Excel files with the MMDDYYYY embeded in their file names. After combining and transforming, the Source.Name field includes the MMDDYYYY...
Just tested and that mmddyyyy text string couldn't be parse as a date even if I added a culture. Try this custom column
let dt = Text.BetweenDelimiters([Column1], " ", ".x"), yr = Number.From(Text.End(dt, 4)), mo = Number.From(Text.Start(dt, 2)), dy = Number.From(Text.Range(dt,2,2)) in #date(yr, mo, dy)That's just foolproofing which files to get. I or someone else might erroneously save a non-relevant file in those folders.
Interesting.... I've never thought of importing files from a folder with various files, file types; I always set up a folder/subfolder exclusively for the imported files.
That's just foolproofing which files to get. I or someone else might erroneously save a non-relevant file in those folders.