B
Bongard
Hi, I am using a parameter in two different fields of a query. The
first is (As Of Date) where the Criteria is <=[Enter an As of Date] and
that is working fine. The second parameter is the one that is not
working. The field is a datediff field that looks like this:
DateDiff("d",[DATE],[Enter an as of Date])
criteria is: >=[Aged Days]
Where [DATE] is the loan origination date and the [Enter an as of Date]
is going to cut off transactions that occurred after the As Of date.
The idea with the second parameter is to only display loans that have
aged greater than x amount of days by the as of date and to show all
transactions on those loans that occurred before the as of date.
For example loan #123
[Date] [TranDate] [Amount]
7/1/06 7/5/06 50.00
7/1/06 8/5/06 100.00
7/1/06 9/5/06 150.00
If the user selcted an as of date (8/10/06) and AgedDays (60) this loan
should not display. Instead the first parameter is working and only
shows the first two transactions in the query but the second parameter
does not eliminate the results saying the loan hasn't aged 60days. I
would expect to see no results for this loan number when I ran the
query with these parameters.
Thanks so much!
Brian
first is (As Of Date) where the Criteria is <=[Enter an As of Date] and
that is working fine. The second parameter is the one that is not
working. The field is a datediff field that looks like this:
DateDiff("d",[DATE],[Enter an as of Date])
criteria is: >=[Aged Days]
Where [DATE] is the loan origination date and the [Enter an as of Date]
is going to cut off transactions that occurred after the As Of date.
The idea with the second parameter is to only display loans that have
aged greater than x amount of days by the as of date and to show all
transactions on those loans that occurred before the as of date.
For example loan #123
[Date] [TranDate] [Amount]
7/1/06 7/5/06 50.00
7/1/06 8/5/06 100.00
7/1/06 9/5/06 150.00
If the user selcted an as of date (8/10/06) and AgedDays (60) this loan
should not display. Instead the first parameter is working and only
shows the first two transactions in the query but the second parameter
does not eliminate the results saying the loan hasn't aged 60days. I
would expect to see no results for this loan number when I ran the
query with these parameters.
Thanks so much!
Brian