How to Filter Data By Year

(0) Share

Report

Posted on by CheddahChase

115

Hi,

I was wondering if you could filter by year. I have done by month before, but when I try "StartOfYear" it does not work... does anybody know the best course of action to filter by the start of the year until now?

My code I attached may be wrong because I based it off of the month filter, I made.

Thanks in advance.

Edit:

Someone stated that I had a space in the title of the column. I fixed it and it still had an issue. The AI helper stated this:

The error you're encountering is due to referencing the 'startOfYear' function, which is not defined or valid in the context of the 'Get_items_Report_Approved' action. To fix this, consider using a different function or ensuring that the correct function is being called for the date manipulation you intend to perform.

Categories:

Business Process Flows

FormatDate.png

FIlter Query.png

All responses (1)

Answers (0)

Suggested answer

David_MA 11,512 Super User 2025 Season 1 on at

Like (3)

Report

How to Filter Data By Year

Your approach is correct, but I think there is a typo in your expression Query filters require that you use the internal name of the fields in the filter. In your screen shot, I see a space in the filter query for the Request Date. Internal names would never contain a space. You can get the internal name of a field by going into the list settings and opening the field. At the end of the URL will be the internal name. Use that in the filter.