在列表视图中按sysdate月份和年份进行过滤 [英] Making a filter by sysdate month and year in list view

问题描述

Hello,

我有一个自定义列表，其中包括以下几列:操作，月-年和计数，其中操作是文本字段，月-年类似于"2017年9月"， 计数"是该特定月份的操作计数.

I have a custom list that includes the following columns: Action, Month-Year and Count where Action is a text field, Month-year like "Sep-2017" and Count is the count of the action in this specific month.

我需要做的是创建一个视图，该视图显示与当月相关的记录，因此在视图过滤器中，我编写了此

What I need to do is to create a view that shows the records related to current month so in the filter of the view, I wrote this 

年月等于  = TEXT([Today]，"MMM")&-"& YEAR([Today])

Month-Year is equal to =TEXT([Today],"MMM")&"-"&YEAR([Today])

但是什么也没有发生，并且视图什么也没有返回，所以有没有办法实现这一目标?

but nothing happens and the view returns nothing so is there a way to achieve this??

谢谢

最好的问候，

Marwa Mostafa

Marwa Mostafa

推荐答案

Marwa，您好-您不能在计算列中使用Today.为什么不制作月份列并对此进行过滤?

Hi Marwa- you can't use Today in a calculated column. Why not just make a month column and filter on that?

这篇关于在列表视图中按sysdate月份和年份进行过滤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！