filtering on dates

[ntudev]

I have 2 columns with 2 different dates.

Column 1             Column 2

4.28.2022          random dates

I need column 2 to only filter on dates that's beginning 4.1.2022 and up and this is for a monthly report. Can anyone help me out here?

[IraWatt]

@ntudev is this the kind of formula you are looking for:

[ntudev]

so this is the filter i have now. since i run this report monthly i cant just put a date in there, so i'm hoping  that the system will look at column 1 which has todays date (or the date i run the report) and pull the report starting from 1st of the month to todays date, example if today is 4.28 i need the report to pull everything in column 2 (which has random dates)  that is from 4.1 to 4.28

this is the ideal column. everything between 4.1 to 4.28.

Column 1        Column 2 

4.28                  4.1

                         4.3

                         4.15

[ntudev]

forgot to mention, in my filter i'm going straight to column 2 and putting a 2022-04-01 filter on it.

[ntudev]

here is an example finally

[stvnhdmpa]

If you are doing it monthly for that month, then you could use a "DateTimeFirstofMonth".  If you need to go backwards a month you could do a datetimeadd to go backward one month.

[stvnhdmpa]

@ntudev - See if this helps.

[ntudev]

thanks @stvnhdmpa , i was hoping it would be something simple like just putting a ">="

[Jon-Knepper]

Since this is for a monthly report, is your goal to locate records that are within a certain date range?  Are you trying to identify the Month and Year of each date so that you can easily classify which Month/Year the record belongs to?

[ntudev]

@Jon-Knepper yes i want all dates within a certain date to show up in column 2