Forum Discussion
DataFormat.Error: We couldn't parse the input provided as a Date value.
Resident RockstarAnonymous -
I think it is the ending 'Z'. I can't seem to find the acceptable DateTime.From... which listed all the correct formats; all i could find was https://docs.microsoft.com/en-us/powerquery-m/datetime-fromtext.
Try removing the 'Z'.
Edit - take a look at https://docs.microsoft.com/en-us/powerquery-m/datetimezone-fromtext which shows an example of trailing 'Z'.
Hello ChrisMendoza
Remove Z from where? From the base?
Because in my report I have 3 columns with dates, and all are in dd/mm/yyyy format :smileysad:
- ChrisMendoza
Anonymous -
To be honest, after my edited response I am not terribly sure what the problem is.
Anonymous wrote:Because in my report I have 3 columns with dates, and all are in dd/mm/yyyy format :smileysad:
The error message shows differently though as yyyy-mm-ddThh:mm:ssZ. Which should fulfill the requirements of DateTime.FromText( ) which I was thinking the issue was.
I was responding in my experience where I had a format of yyyy-mm-dd hh:mm:ss which neccesitated inserting the 'T' .