Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Find Max date from previous month
Added on October 28, 2023 8:21AM
Likes: 0
Replies: 1
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: 2,418 NeuronCome 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.