Answered

Items from last 3 months

(0) Share

Report

Posted on by nikola_bgd

Hi,

I'm trying to get SharePoint list items from the last 3 months from a column called DueDate. I'm trying with this formula in the filter query, but it's not working.. (items are not from last 3 months).

DueDate ge '@{formatDateTime(startOfMonth(getPastTime(3,'Month')),'MM-dd-yyyy')}' and DueDate lt '@{formatDateTime(startOfMonth(utcNow()),'MM-dd-yyyy')}'

Any ideas anyone?

Categories:

Building flows

All responses (4)

Answers (1)

Sort by

Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi there,

Just to be super clear: are you looking for the last 90 days, or the last 3 months - and does that "last 3 months" include this month? (This month, last month, the month before, in full?)

I tried out this formula, and it brought back the dates of January 1st to April 1st.

ReviewDate ge '@{startOfMonth(getPastTime(3,'Month'))}' and ReviewDate lt '@{startOfMonth(utcNow())}'

These are the dates on my list - and it only retrieved two of them - so it did it correctly:

Are you able to tell me - if your flow triggered on April 15th, what is the earliest date you would expect to see?

Cheers,

Rhia
nikola_bgd 93 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey, thanks for helping out!
90 days or 3 months, basically it doesn't make a lot of difference, any of the two would be good.
Last 3 months include this month.
Verified answer

Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Ah great! Then, the above formula should work for you. I used it in the Filter Query field of my Get Items action - you'd just replace ReviewDate with DueDate. Let me know how it goes.
nikola_bgd 93 on at

Like
a
(0)

Report
Copy link

Link copied!

This works 🙂