Filter a Date field to return all items <= first day of the current month

Hi everyone, I am using the filter tool, where each month, I manually alter the date to return the results I need (shown below). I would like to add this workflow to a scheduler service, but cannot because of my manual changes.

How do i convert the calculation below (still using my filter tool) to return

Current State

[MemberEnrollmentDate] <= "2019-05-01"

Future State Requirement

[MemberEnrollmentDate] <= first day of the current month (based on the day the workflow us run)

*so, if i ran the workflow on 05/31, it would return member enrollment for May (and earlier), but if i ran the workflow on 06/01, it would now return member enrollment for June (and earlier).

Thank you ahead of time

Date Time

Preparation

Scheduler

Accepted answers

Kenda

@alphabex18

Try changing your DateTimeFirstOfMonth() to

todate(DateTimefirstOfMonth())

If this doesn't work, do you have some sample data you could provide?

All comments

Kenda

Hey @alphabex18

Lucky for you, this is easy in Alteryx! Simply change your expression to:

[MemberEnrollmentDate] <= DateTimeFirstOfMonth()

alphabex18

Thank you Barnes, that worked perfectly. However, I have an "AND" statement in another filter with the same concept, that I get zero results when i replace the '2019-05-01' with the DateTimeFirstOfMonth(). Any suggestions?

[MemberEnrollmentDate] = [GrpEnrollmentDate]

AND
[MemberEnrollmentDate] = DateTimeFirstOfMonth()

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703