Find Max date from previous month

Kkmakv
Level 1
Find Max date from previous month

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 Kudos
1 Reply
Turribeach

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.