Trying to create a filter based on today - 90 days

Michael Litterello
Michael Litterello Altair Community Member
edited June 2022 in Community Q&A

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. 

Tagged:

Answers

  • CPorthouse
    CPorthouse
    Altair Employee
    edited June 2022

    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.

  • Baba_Majekodunmi_703
    Baba_Majekodunmi_703
    Altair Employee
    edited June 2022

    Hi 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.

    How to Import Data into SQL

     

    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.

Categories