IF Statement for Date Selection via Formula Tool

[CDIns]

Trying to set up an automated work flow that is pulling out data from a larger data set based on the date field. This exercise is completed in the first week of the month for the previous month. For example, In May I'll be looking for just April data. To make things even more complicated, my data set is year to date. 

Is there an IF Statement I can apply here, something like:

IF [ReportingDate]> Current Month end date minus 2 months AND <= Current Month end 

For May something like:

IF [ReportingDate]>03/31/25 and <=04/30/25  

I am trying to avoid having to update my data parameters each month. 

Any ideas? 

Thanks in advance, Community!

[Deano478]

@CDIns the best approach would be to first get the previous month start and previous month end and then create a dynamic filter from there 

[binuacs · Accepted solution]

@CDIns 

[ReportingDate] > toDate(DateTimeTrim(DateTimeAdd(DateTimeToday(),-1,'month'),'lastofmonth'))
AND
[ReportingDate] <= toDate(DateTimeLastOfMonth())

[CDIns]

Hi Binuacs, thank you for the reply. Quick follow up, since we are currently in April, how would I get it to to be <02/28/25 and <= 03/31/25? 

Please disregard- I was able to back into it using the formulas you provided above

Thanks!