How to filter dates less than current day

[abalo006]

I have a dataset that has a list of dates and days of the week, is there a way I can filter my dataset for dates that are less than or equal to the current date?

I tried the formula date = now() but I don't think that's working, it just filters all my data out.

---

Operating system used: windows

[tgb417]

@abalo006 

When it comes to doing calculations, formulas and filtering in Dataiku DSS. You have to parse the dates to the official Java and Dataiku DSS format before trying to do any of these things,   This step can be taken in a prepare recipe.  

Here is a link to a brief tutorial on the subject

https://knowledge.dataiku.com/latest/data-preparation/dates/concept-date-handling.html

Here is some detailed documentation on the use of dates in Dataiku DSS. 

https://doc.dataiku.com/dss/latest/preparation/dates.html

Hope this helps a bit  

[tgb417 · Accepted solution]

@abalo006 

Once you have parsed the dates you can filter in many ways

There is a dedicated date filter step you can add to a visual prepare recipie.

https://doc.dataiku.com/dss/latest/preparation/processors/filter-on-date.html

You can also use the formula filter to filter as well.  Here is the documentation for that type of step.

https://doc.dataiku.com/dss/latest/preparation/processors/filter-on-formula.html 

Finally this may help in the date section.

https://doc.dataiku.com/dss/latest/preparation/filter-flag.html#filter-on-date-range

However, you must first have a parsed date to do any filtering.  

[tgb417]

@abalo006 

Glad to be of assistance.  Hope you are having a wonderful day.