Query with conditional formatting?

[vidus]

I have a field called duedate, this has conditional formatting to be a different color at: due in 3 weeks, due in 1 week, and overdue. We have a query to display these, so in the conditional formatting we have the following:

expression is: [DaysRemaining]<8 and etc for the other dates.

So can I create a query button to display all the jobs due within 8 days etc??

Played around a bit but I cant make it work.

 

[John Big Booty]

IN your query put the following in the Criteria field under [duedate]

>=Date() And <=Date()+8

This will return all due dates that fall within the next eight dyas

 

[vidus]

IN your query put the following in the Criteria field under [duedate]

>=Date() And <=Date()+8

This will return all due dates that fall within the next eight dyas

This is perfect! I didnt know I could do that separate from the daysremaining query.

One question though, for the query to see overdue jobs I simply put in:
>=Date() And <=Date()+0

..but that doesnt seem to return any results.. neither did -0. I guess we can do without that one but can it be done?

 

[Galaxiom]

Adding or subtracting zero makes no difference.

>=Date() And <=Date()

Since a date cannot be both greater than and less than today this should return jobs whose date is equal to today.

However if your date field is actually a Date/Time value formatted as a date then you won't get any results.

 

[vidus]

Adding or subtracting zero makes no difference.


Since a date cannot be both greater than and less than today this should return jobs whose date is equal to today.

However if your date field is actually a Date/Time value formatted as a date then you won't get any results.

Not sure I really understand... why cant a date be less than today? wouldnt that make it overdue? This one gives no results. Our date field is a date formatted field.

 

[Galaxiom]

Of course a date can be less than today

But your test is for both (greater than or equal to) AND (less than or equal to) today.

 

[vidus]

Of course a date can be less than today

But your test is for both (greater than or equal to) AND (less than or equal to) today.

haha.. got it now. thanks Galaxiom.