Find Max date from previous month
Kkmakv
Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 3 ✭✭✭
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
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,987 Neuron
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.