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?

[stvnhdmpa]

@ntudev Like this in your filter?

[Date1] >= "2022-04-01"
AND
[Date2] >= "2022-04-01"

[ChrisTX]

Use a Filter tool, and select the radio button for Custom filter:

[Column 2] >= [Column 1]

[ntudev]

sorry i may have written my explanation wrong. I need column 2 to show the 1st of the month of column 1. So whatever date we have in column 1 then column 2 should just show the 1st of that month.

[IraWatt]

Hey @ntudev,

you can use the datetimetrim function:

[ntudev]

how would i make it more than 1st of the month?

[IraWatt]

Hey @ntudev, What do you mean by more then the 1st of the month? You could use the datetimeadd function to add a given number of days or months on if you want.

[ntudev]

i want to say >= firs of the month.

[ChrisTX]

Can you provide sample input and output, in Excel?  I don't think I understand your requirements.

Chris

[stvnhdmpa]

@ntudev  - Can you mock up some some sample data with the results you need to achieve?  I'm struggling to understand the requirement of this one.

@IraWatt - The DatetimeTrim is brilliant  I wish I new about that a year ago.  I came up with a workaround, but it wasn't pretty.