Ask Experts Questions for FREE Help !
Ask
    LTCRAO's Avatar
    LTCRAO Posts: 0, Reputation: 1
    New Member
    		  
    #1

    Jan 7, 2011, 10:50 PM
    Computing two dates when one is blank
    Can someone please help me! I want to compute in an Access database how many days an item has been in storage to appear in my Total days. These are my fields.
    1. Arrival date =when the item arrived in storage
    2. Dispatch date = when the Item was picked-up
    3. Total days = The number of days an Item has been in storage before it was dispatch. If it has not been dispatched (dispatched date is blank) I want to compute today's date minus the arrival date.
    Thank you
    V/r
    Rich
    rpray2007's Avatar
    rpray2007 Posts: 319, Reputation: 23
    Full Member
    		  
    #2

    Jan 14, 2011, 04:20 PM
    You might try:

    =DateDiff("d", [OrderDate], [ShippedDate])

    which should provide the difference as number of days.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Computing [ 4 Answers ]

Differences and the advantages/disadvantages of Access ,Visual basic,and SQL.

Computing Present Value [ 1 Answers ]

What is the Present Value of receiving $500 per year each year for 4 years if the first payment is one year from today (discount rate = 8%)?

Do doctors make mistakes about conception dates and due dates? [ 3 Answers ]

I don't understand, can doctors be wrong about conception dates and due dates?

Computing [ 1 Answers ]

(1) A rectangular block of wood is measured to have the dimensions 11.2 cm x 3.4 cm x 4.10 cm. Compute the volume of the block, showing explicitly (by underlining) how doubtful figures are carried through the calculation, and report the final answer with the correct number of significant figures....

View more questions Search