I need help to those who have well knowledge in msaccess, my concern right now is on how to get date difference from date and with the number of days given.
  example: date is 01/25/2008
           number of days given is 10 days
           01/25/2008 - 10 days in order to result 01/15/2008

can anyone can help me pls.....

thanks
Ben

Where are you generating this date difference? If in a query, you can do:

SELECT RecordID, RecordName, RecordStartDate, RecordEndDate, DateDiff("d", RecordStartDate, RecordEndDate) As Days FROM MyTable

If you want the number of days from the record date to today, you can do this:

SELECT RecordID, RecordName, RecordStartDate, RecordEndDate, DateDiff("d", RecordStartDate, Date()) As Days FROM MyTable

You can put similar code on a form event etc.

Did that help?



mmcdonal

Look it up at: http://wrox.books24x7.com