How do i use a query to display customers up for review

[Epsilon101]

This is in reference to thread705-869085

How do i create a query that will list customers where a check box is not ticked and the date being checked is todays date - 4 working days or more, by that i mean weekends are not counted.

??

---------------------------------------
Thanks for any help!

 

[BobJacksonNCI]

Working with dates is needed frequently, so there are many threads and FAQ's about that topic. For example: faq705-4531

You'll need a function which can be referenced by your query.

Look at the FAQ and if you have questions how to create your own, post here. It would be most efficient to include actual table, field and function names.



HTH,
Bob

 

[lupins46]

Select * from mytable where checkfield = false and
mydate = (iif(weekday(Date()) = 6, Date()-4, Date()-6))

Use your own table and field names.