try the below as you might forgot to add braces to the parameters:
ALTER PROCEDURE [dbo].[viewMaterialByDate]
(@fromDate date,
@toDate date)
AS
Select MaterialID,Material,Topic FROM StudyMaterial,Topic
WHERE Topic.TopicID= StudyMaterial.TopicID and
[Date] >=@fromDate and [Date] <= @toDate