Find Max date from previous month

Kkmakv Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 3 ✭✭✭

October 2023 in General

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

0 · Share on FacebookShare on Twitter

Answers

• 

  Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023, Circle Member Posts: 2,677 Neuron

  October 2023

  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.

  1 · Share on FacebookShare on Twitter