报告日期过滤Or => [英] Report Date Filtering Between Or =>

问题描述

我试图通过使用两个日期参数来过滤我的数据。

我遇到的问题是，如果我想今天看到结果，我只想输入作为开始日期的04/03/2009值和作为结束日期的04/03/2009，但是当我输入这些值时，我得到一个空白的报告我试过使用

在@startD和@endD之间创建

我也尝试使用
























































>解决方案

我试图通过使用两个日期参数来过滤我的数据。

我遇到的问题是，如果我想今天看到结果，我只想输入值04/03/2009作为开始日期和04/03/2009作为结束日期，但是当我输入这些值时，我得到一个空白报告我尝试使用

创建在@startD和@endD之间

我也尝试使用

StartD< = createdon A nd EndD> = createdon

但是Where子句都没有产生正确的结果任何想法赞赏

I am trying to filter my data by using two date parameters.

The problem I am having is that if I would like to see results for today only I would like to enter the value 04/03/2009 as start date and 04/03/2009 as End Date but when I enter these values I get a blank report I have tried using

createdon Between @startD and @endD

I have also tried using

StartD <= createdon And EndD >= createdon

but neither Where clause is producing the correct results any ideas appreciated

解决方案

I am trying to filter my data by using two date parameters.

The problem I am having is that if I would like to see results for today only I would like to enter the value 04/03/2009 as start date and 04/03/2009 as End Date but when I enter these values I get a blank report I have tried using

createdon Between @startD and @endD

I have also tried using

StartD <= createdon And EndD >= createdon

but neither Where clause is producing the correct results any ideas appreciated

这篇关于报告日期过滤Or =&gt;的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！