I'm not sure you need to use the DATEFROMPARTS function here. To see the date in a specific format, you use CONVERT or FORMAT. CONVERT will work in any version of SQL Server.
SELECT
CONVERT(varchar(10), appl_stock.Date, 101) AS Date
FROM dbo.appl_stock
You use DATEFROMPARTS to construct a DATE FROM its PARTS. For example SELECT DATEFROMPARTS(2018,12,31)
DATEPART gets you a part of the date if you already have a date. SELECT DATEPART(DAY, '20181231')
What is not obvious from my example is that the result of the first select is of type DATE and the inputs given to it are integers. The result of the second select is an INTEGER, and it takes a DATE as the parameters (converting the string to a DATE and then using it)