CALCULATE DATES 3

[baybie]

I have a library Dbase With a table called Sign Out used to track borrowed books. Sign Out table has fields like Book_ID, Member_ID, Date_Out,etc. I want a field in the query called "Due Date" which will be the Date Out+7 and i want the sum total displayed in a Date format. At the moment i have got the query sorted but am unable to change the properties for the Due Date field to display as a Date as opposed to a general number.
Make sense?

 

[shannonp]

To work out Due Date:

Due Date: DateAdd("d", 7, [Date Out])

TO show as a Date try one of the options below:

OPTION A: Right mouse click on 'Due Date' and click properties. Under the 'General Tab' change format to either "short date", "medium date" or "lond date" (no quotes).

OPTION B: Alter the Due Date Formula slightly...

Due Date: Format(DateAdd("d", 7, [Date Out]),"medium date&quot

Hope this answered your question

 

[baybie]

Thanks for the above replies,
Would you all happen to know of a query which would give me those loan outs that are past the 8 day deadline?

 

[mrf1xa]

You can use the DateDiff function to establish time between two dates, so:

DateDiff("d",[Dateout],Date())>8

should show all cases where the difference between the date out and currentdate exceeds 8 days.

HTH
Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....