create table #table1 (coldate date)
insert #table1 values ('19000101'),('19000202'),(getdate())
declare @sql varchar(2000)
set @sql = 'select iif(coldate < ''19000102'','''',convert(char(10), coldate, 101)) coldate from #table1'
exec (@sql)
declare @coldate date = getdate()
select format(@coldate,'dd-MM-yyyy')
select format(@coldate,'d','en-gb')
select convert(char(10), @coldate, 105)
select convert(char(10), @coldate, 103)
Will try and brb