范围之间的自定义列匹配日期
我想知道是否可以创建一个自定义列以匹配适合特定日期范围之间的日期。我尝试使用以下自定义公式，但似乎没有返回任何内容，
=if [#"Start Date (Calculated 2)"] <= #date(2019,09,01) and [#"Start Date (Calculated 2)"] < #date(2022,04,01) then "Yes" else [#"Start Date (Calculated 2)"]
但是它不匹配任何内容
I'm wondering if it's possible to create a custom column to match dates that fit between specific date ranges. I've tried using the below custom formula but doesn't seem to return anything
=if [#"Start Date (Calculated 2)"] <= #date(2019,09,01) and [#"Start Date (Calculated 2)"] < #date(2022,04,01) then "Yes" else [#"Start Date (Calculated 2)"]
However it doesn't match anything
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
机械上，如果您的列是日期，则您的公式可以正常工作，除了逻辑毫无意义，
您正在寻找日期＆lt; 01Sep2019 and ＆lt; 01apr2022
您可能想将其更改为此，以取代它第一＆lt;与＆gt;
Mechanically, if your column is a date, your formula works fine except the logic makes no sense
You are looking for a date <01Sep2019 and <01Apr2022
You probably want to change it to this, replacing the first < with >