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.
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.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
115
Share
Report
All responses (
Answers (
