# Thread: formula for date question

1. I received a description of a problem (no example) from a former student today. Have a question maybe you can help me solve.

Here is his original question:
I need to propagate a list of cells that are 14 days
from reaching the date in the cells. This is not working "(14
day)<(DbDate)" this is Access 2003.

I am guessing what he is trying to say here. I think in a query he needs a new column to contain a formula like:

Getting Close: =IF([DueDate]=[OverDue]-14,[DueDate],""]) but how would he write this

HELP! My mind is gone today...heck it's gone on most days, you've probably guessed that by now...but appreciate the help on this.

He may also just need a filter...any help at all

2. Create a field in the query that subtracts the appropriate fields. Set the criteria to 14.

3. Ok, here is a better understanding of what he is looking for:

Proj number Location Description Req comp date Act comp date remarks

He wants to be able to query a list of incomplete jobs
within 14 days of req comp date. The act comp date will have a null criteria
to identify it to be incomplete as I understand it.

Can you help me with the Access query formula that will help him get what he wants?

Thank you.

Originally Posted by teachesms
I received a description of a problem (no example) from a former student today. Have a question maybe you can help me solve.

Here is his original question:
I need to propagate a list of cells that are 14 days
from reaching the date in the cells. This is not working "(14
day)<(DbDate)" this is Access 2003.

I am guessing what he is trying to say here. I think in a query he needs a new column to contain a formula like:

Getting Close: =IF([DueDate]=[OverDue]-14,[DueDate],""]) but how would he write this

HELP! My mind is gone today...heck it's gone on most days, you've probably guessed that by now...but appreciate the help on this.

He may also just need a filter...any help at all

4. Create a column with the formula of DaysOut:[rew comp date] - Date(). Set the criteria to <=14.
Set the Act Comp field's criteria to "Is Null" (without the quotes)

5. Originally Posted by mbarron
Create a column with the formula of DaysOut:[rew comp date] - Date(). Set the criteria to <=14.
Set the Act Comp field's criteria to "Is Null" (without the quotes)

Will let you know if this works for him when he emails me back. Thank you for helping. It is MCI's fault that he can't do this for himself, as MCI blocks anything that looks like a chat room where he works, so I am having to do the asking myself today (which I always told them I would). I still give Woody's all the KUDUs.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•