Exclude last 4 days of month filter

[markalves]

Hello,

I am filtering current month in a set of data which spans a half of a year.  But I also want to exclude the last 4 days of current month.  What would the formula be? I realize that my filter is not very sophisticated, and I should use a formula that finds the current month instead of hard coding the current month every month. Please help.

[Qiu]

@markalves 
Maybe it is a bit lengthy 😁
the left anchor is the result of filtering, and the J anchor is the dates that should be filtered out.

[RolandSchubert · Accepted solution]

Hi @markalves ,

if I got you right, this may solve your problem:

DateTimeFirstOfMonth() returns the first date of the current month

DateTimeLastOfMonth() is the last date of the current month, using DateTimeAdd you can "adjust" the date to exclude the last 4 days.

Let me know if it works for you.

Best,

Roland

[atcodedog05]

Hi @markalves 

My take on this

Workflow:

Hope this helps : )

[markalves]

Thank you.  This worked perfectly.