列名称大于[计算字段]的筛选 [英] Filter with Column Name Greater than [Calculated Field]

查看:88
本文介绍了列名称大于[计算字段]的筛选的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有2个计算字段:

开始上个月和结束上个月 -  这些工作很棒(仅限日期)

Start Previous Month and End Previous Month -  these work great (both Date Only)

我还有一个名为"案例日期"的字段

I also have a field called "Case Date"

我想要一个介于这些之间的过滤器2个计算日期:

I want a filter that falls in between those 2 calculated dates:

案例日期大于或等于[上个月开始]

Case Date is greater than or equal to [Start Previous Month]

案例日期小于或等于[结束上个月]

Case Date is less than or equal to [End Previous Month]

当我点击"确定"完成视图时,我收到一条错误消息,上面写着

When I click 'OK' to finalize the view, I get a error message that says

"过滤值不是支持的日期格式"它突出显示文本框中的[开始上个月]。我已尝试使用和不使用方括号,但无济于事。 

"Filter value is not in a supported date format" and it highlights [Start Previous Month] in the textbox. I've tried with and without the square brackets, but to no avail. 

任何人都知道我该怎么做?

Anyone know how I can do this?

推荐答案

你可以为你的问题上传快照吗?

can your upload the snapshot for your issue?


这篇关于列名称大于[计算字段]的筛选的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆