Date Calc/Criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anthony Viscomi - 30 Nov 2006 19:27 GMT

I am trying to filter records via a query; the query has a Date field
"DueDate". I would like to display the records that meet the following date
criteria:

<Now()

>Now() but only 10 days into the future

Thanks in advance!
Anthony

Reply to this Message

kingston - 30 Nov 2006 19:41 GMT

Do you mean this criteria:

<Now() Or >Now()+10

>I am trying to filter records via a query; the query has a Date field
>"DueDate". I would like to display the records that meet the following date
[quoted text clipped - 5 lines]
>Thanks in advance!
>Anthony

Reply to this Message

Anthony Viscomi - 30 Nov 2006 19:49 GMT

Actually I mean this:

<Now() Or =Now()+10

> Do you mean this criteria:
>
[quoted text clipped - 10 lines]
>>Thanks in advance!
>>Anthony

Reply to this Message

kingston - 30 Nov 2006 19:59 GMT

In the query, on one criteria line enter <Now() and on another criteria line
enter Now()+10.

>Actually I mean this:
>
[quoted text clipped - 5 lines]
>>>Thanks in advance!
>>>Anthony

Reply to this Message

Anthony Viscomi - 30 Nov 2006 19:56 GMT

I had a "Mental Breakdown"; all I needed was:
<=Now()+10

> Do you mean this criteria:
>
[quoted text clipped - 10 lines]
>>Thanks in advance!
>>Anthony

Reply to this Message