Filtering on past 6 months data

Hi, i am trying to filter my data to the previous 6 months, from "today's date".

So far i have used the datetimenow() to create a new field called "Today's Date", and now i am trying to figure out how to filter my records to only show the previous 6 months based upon the date in this field.

Is this the right way to go about filtering my data to only show past 6 months based upon the date i run my report?

Thanks

Date Time

Accepted answers

LordNeilLord

Hey @RogerA

My sincere apologies, I was typing quickly and should have checked first the formula should be:

[Today's Date] >= DateTimeAdd(DateTimeToday(), -6, "months")

Neil

All comments

LordNeilLord

Hey @RogerA

In your filter tool you can add the following to filter on the last 6 months;

DateTimeAdd([Your Date], DateTimeToday(), -6, "months")

Neil

RogerA

Thanks, so this is what it looks like with my actual field added into the filter:

DateTimeAdd([Today's Date], DateTimeToday(), -6, "months")

"Today's Date" is the new date field i have added into the data. But i am getting the message "Wrong number of parameters for the function "DATETIMEADD".

Any ideas? @LordNeilLord

LordNeilLord

Hey @RogerA

My sincere apologies, I was typing quickly and should have checked first the formula should be:

[Today's Date] >= DateTimeAdd(DateTimeToday(), -6, "months")

Neil

dlopez

UPDATE: I think I figured it out

would it be something like this...?

[Today's Date] >= DateTimeAdd(DateTimeFirstOfMonth(), -6, "months")

---------------------------------------------------------------------------------------------------------------------------------------------------------------

@LordNeilLord

what if you wanted to go back six months from the first of the month, and not today's date?

Example, I want filter data on the past six months, not from today's date (07/06/2020) rather I want to filter the past six months from 07/01/2020).

Any idea, how to adjust the formula for this?

Cheers,

david

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167