🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Trying to create a filter based on today - 90 days

Michael LitterelloUser: "Michael Litterello"
Michael Litterello
Altair Community Member
Updated by Michael Litterello

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

English
Monarch
Sort by:
1 - 2 of 21
    CPorthouseUser: "CPorthouse"
    CPorthouse
    Altair Employee
    Updated by CPorthouse

    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_703User: "Baba_Majekodunmi_703"
    Baba_Majekodunmi_703
    Altair Employee
    Updated by Baba_Majekodunmi_703

    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.

Quick Links