日期表达问题 [英] Date Expression Question

问题描述

下午好，


我在为查询编写表达式时遇到困难。


我希望Overdue：返回逾期"如果[申请 - 下一个]中的日期介于当前日期和当前日期减去一个月之间（例如，返回2017年5月30日至2017年6月30日之间的任何日期）。


如下所示：

Good Afternoon,

I am having difficulty writing an expression for a query.

I would like Overdue: to return "Overdue" if the date in [Application-Next] is between current date and current date minus one month, (for example, return any dates between 30 May 2017 through today, 30 June 2017).


Something like the below:

展开 | 选择 | Wrap | 行号

推荐答案

我明白了我错误地在表达式示例中键入了Application-Last。我在尝试在查询中编写表达式时仍使用了Application-Next，但仍然收到语法错误。谢谢。

I understand that I mistakenly typed Application-Last in the expression example. I used Application-Next when trying to write the expression in the query and still received syntax errors. Thanks.

确保]和Between之间有空格。此外，尝试切换日期参数，以便DateAdd（m， - 1，Date（））位于表达式中的Date（）之前。您确定[Application-Last]是日期数据类型吗？

Make sure that there is a space between ] and Between. Also, try switching the date parameters around so that DateAdd("m", -1, Date()) comes before Date() in the expression. Are you sure that [Application-Last] is of date datatype?

您没有说明您实际收到的内容。错误信息？意想不到的价值？ $ *
我唯一看错的是缺少第三个参数。肯定把第一个值作为下限很有道理，就像之前的空间一样，但是我不认为是问题。


正如我所说，我们不要我不知道你在看什么，所以它只是真正的猜测。

You give no indication of what you actually receive. Error message? An unexpected value? Hard to work when information isn''t shared.

The only thing I see wrong is the lack of a third parameter. Surely putting the first value as the lower limit makes good sense, as does a space before Between, but I don''t see either as problems.

As I say though, we don''t know what you''re seeing so it''s just intelligent guessing really.

这篇关于日期表达问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！