Selecting items for a month in a sharepoint list

(0) Share

Report

Posted on by Universal_Power

I have a sharepoint list and I would like to pull the data from it and display it in a gallery for the month, this is the formula that I used:

Filter([@Leave], StartDate= Today(), -1, Months, "dd/mm/yyyy")

This does not work, Is there an alternative? if I use

Filter([@Leave], StartDate=Today(), "dd/mm/yyyy")

I can get it to display for entries made today but I need it to show all entries for the current month, advice? (Leave is the name of the list, startdate is the name of the column which is entered as dd/mm/yyyy in sharepoint)

Categories:

Using Apps Using Formulas

All responses (2)

Answers (1)

Universal_Power 67 on at

Like (0)

Report

Re: Selecting items for a month in a sharepoint list

Awesome that worked perfectly! Thanks!
Verified answer

BhaskarDhone 810 Super User 2025 Season 1 on at

Like (1)

Report
Re: Selecting items for a month in a sharepoint list

try this
Filter( [@Leave], Year(StartDate) = Year(Today()) && Month(StartDate) = Month(Today()) )