From what I'm seeing Databricks doesn't have DECLARE function, how can I ... ?

[Joe_C]

How can I re-write this statement in a way that is compatible for Databricks?

DECLARE @DATE_BEGIN_TEST AS DATE = DATEADD(DAY, - 60, GETDATE());

DECLARE @DATE_END_TEST AS DATE = GETDATE();

[Kaniz]

Hi @Joseph Collins​, We have a similar community thread here.

[Kaniz]

Hi @Joseph Collins​ , We haven’t heard from you on the last response from me, and I was checking back to see if you have a resolution yet. If you have any solution, please do share that same with the community as it can be helpful to others. Otherwise, we will respond with more details and try to help.

[jose_gonzalez]

Hi @Joseph Collins​,

Just a friendly follow-up. Do you still need help or the link shared by Kaniz help you? Please let us know