Database View to display last 3 months data

[meher_sanjiv]

Hi Experts,

I have created a database view joining the request, requested item and user table. But the view is pretty slow when we are trying to access it from Tableau.

Is there a way I can put a condition in the database view to display only the last 3 months data.

I was referring the below link, but that didn't work for me.

Database View where clause Date condition

[Darren Tan]

Hi Sanjiv,

Understand that this is a old thread. But wondering, were you able to resolve your issue? Cause I am also facing the same dilemma. The "where" in database view does not allow to perform date comparison to today's date?

Thanks!

Best regards.

Darren Tan