Hi @Alberto_Umana 

Thank you for your response.

That's the weird thing. The RawDataStartDate only consists of records with datetime stamps. Furthermore I am nowhere in my code casting anything of this to a boolean, or casting anything at all. All I am literally doing is creating a temp table from the raw layer, dropping the silver layer and inserted data from the temp table into the silver layer.

Upon checking the schema of all tables the fieldtype remains a timestamp field. So I just don't understand why I'm getting the error of that it cannot convert timestamp to a boolean while im never casting/converting a timestamp to a boolean field...

Do you have any other suggestions?