Get the Last 3 Months

[KamenRider]

Hi,

Can someone help formulate a formula or filter to get the last 3 months? Data set is attached.

Thanks,

Kamen

[jordanmount6]

One way would be to add a formula tool. First create a column for today using this formula : DatetimeNow()

Then create a column with this formula: DateTimeAdd([today],-3,'months')

Then you can add a filter tool that will be [your date field] > [3 months ago]

[usmanbashir · Accepted solution]

@KamenRider - You can use this in filter. Hope this helps!

[Begin Date] >= DateTimeAdd(DateTimeToday(),-3,'months')

Another option if needing last 3 months from 1st of current month. 

[Begin Date] >= DateTimeAdd(DateTimeFirstOfMonth(),-3,'months')

Another option if needing last 90 days

[Begin Date] >= DateTimeAdd(DateTimeToday(),-90,'days')

[Manoj_k]

hi @KamenRider we can do it both the ways using a filter or  a formula filed. i have attached the screen shot

[KamenRider]

@usmanbashir @Manoj_k @jordanmount6 

Thank you so much