Trying to create a filter based on today - 90 days
Current filter is based on a date but its too much data. I'd like the filter to only gather the last 90 days. I tried using the function but I keep getting an error. Looking for an example to base my filter on.
Find more posts tagged with
Altair EmployeeHi Michael,
Databases
It depends on where you data is coming from. For example, if you data is coming in from a database like SQL, you do have some options to apply filtering before importing it into Monarch in Monarch Classic.
Here's a recording on how to import data from SQL in both Data Prep Studio and Monarch Classic.
Flat Files
If you're importing from a Flat file, such as a report, or csv, or excel file then you can use Chris's formula example is a good place to start, but there might be more options depending upon the data source and other options to bring it into Monarch.
What formula are you trying?
Try something similar to:
Today()-90 > [Formula Column]
Where [Formula Column] is the name of the column you are using to compare to today's date.