Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
How to find Max date from previous month from a dataset using sql for scenario variable. required max date of previous month not last date of previous month.
Operating system used: windows
Operating system used: Windows11
Come up with the SQL that gives the date you want. Then follow the steps in the "Using the results of a previous SQL step":
https://doc.dataiku.com/dss/latest/scenarios/variables.html#using-the-results-of-a-previous-sql-step
The SQL step name must not have spaces.