declare @string varchar(1000), @getPreviousDate date
select @getPreviousDate = dateadd(day,datediff(day,1,GETDATE()),0)
select @string =
'
SELECT * FROM openquery(kelkoospark,''SELECT count(*) from returning_users_device_types WHERE [date] = @getPreviousDate'')
'
select @string
--EXEC (@string)