Power query Filter out non date / Select Date

Hi,
I have a table withe a column containing date and non date values loaded to power query I would like to
remove the non date values.

Workbook attached.

I have tried ;

Please Login or Register  to view this content.

but this only returns the rows above the first ERROR, This is the query called 'filter' in attachment, if someone can explain why it does not work.

So Then I tried;

Please Login or Register  to view this content.

The closest I've got is to use TransformColum, not type ;

=

Please Login or Register  to view this content.

But I can't come up with how to do this for TRANSFORMCOLUMNTYPE , which would be better. Ideally I'd like to use the first example, but as I can't see why this does not work.

Richard.

Hello, Thank you for the response,
yes this woks but I'm still adding columns,

I don't see why

Please Login or Register  to view this content.

Returns the first rows correctly but then fails. this goes if you try Number.From ( [Date]) as well.

As said the closeset I've got is

T

Please Login or Register  to view this content.

But this still needs the column type transforming and I can't figure how to get 'try' into columtype

Please Login or Register  to view this content.

it just ignores this. I'll leave this open and see if there are any more ideas.

Richard.

Thank you , I was had just found that very function on Stack

https://stackoverflow.com/questions/...wer-query-list


Do you know why the

Please Login or Register  to view this content.

Works until it hits the first ERROR, whch it inclused in the result.

Richard.