I am creating a database view and need to format date field as yyyy-MM-dd while also supressing null dates which are showing up as 01-01-1900. The statement I am using is:

CAST(ISNULL(FORMAT(my_data_dte, ‘yyyy-MM-dd’), ”) as date) as ‘My_Date’,

I’ve tried various ways including IFF and CASE but had no luck 😞 

Would appreciate any suggestions. 

Thank you

​I am creating a database view and need to format date field as yyyy-MM-dd while also supressing null dates which are showing up as 01-01-1900. The statement I am using is: CAST(ISNULL(FORMAT(my_data_dte, ‘yyyy-MM-dd’), ”) as date) as ‘My_Date’, I’ve tried various ways including IFF and CASE but had no luck 😞 Would appreciate any suggestions. Thank you  Read More

​