Query Question

[AGoodGuy]

I have a question. Since I dont work on the weekends I have to still account for data for Friday and Saturday since my daily data reflects the day before. I have a field name that I focus on. The field names is Expiration date and I have it as >=Date()-32. Since I am not in the office to record the numbers for Friday and Saturday how would I use the fieldname or what criteria would I use to get my data from Friday and Saturday. Do I say >=Date()-31 (for Saturday) and >=Date()-30 for Friday? Your thoughts??

 

[lameid]

Is the issue that you are recording the data on the wrong day therefore expiration has the wrong value.... I think I am missing a step or key piece of information... Perhaps if you describe what you are trying to do instead of just the steps it will make more sense.