Forum Discussion
Unable to Convert list output to Date type
Hi, I have this: The output needs to be in date type something that Date.StartOfYear() function would produce. I am unable to convert the data type to date type. Kindly help me out. ...
The FilterOutUnnecessaryColumns[Min Date] is a column reference that returns a list, and List.Combine is putting those two lists together for List.Min. Also, the pic with the error is only showing that there was an error with another query (not shown in pic), there may not be an issue with the Min Date and Max Date queries. Which query actually had the error?
Pat
This is the error:
The date table has no errors:
Your Min and Max queries are sourced by the FilterOutUnnecessaryColumns query. Does that have data? To isolate the issue, you could hard code a list of dates to your min and max queries to see if it is the Date Table or FilterOut query that has the issue.
{#date(2021,1,1), #date(2021,6,1)} // example list of dates
Pat