Anything you may get from people on the internet is simply opinion.  You need to contact Microsoft or your software provider for the definitive answer you seek.
Even then you...

Here is my suggestion.  Start looking at your data.  No filters (meaning no WHERE clause) and make sure the result set is what you are expecting.  You may also want...

Or this:

CREATE TABLE [dbo].[test](
  [id] [int] NULL,
  [date] [date] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[test] ([id], [date])
VALUES (1, CAST(N'2018-07-16' AS Date))
,...

What does this function do:  [MyDB].dbo.MyProc.
Where does this column come from: [SomeQuery].