Calculating Months Between Two Dates in Access? RSS

• • Reply
  

  jdyer

  Member

  250 Points

  50 Posts

  Calculating Months Between Two Dates in Access?

  Oct 08, 2003 06:23 PM|LINK

  I am developing a web-based Access dbase and I need to calculate the number of months between the current data and the date of employment of the user. The information will be displayed in the Acces dbase table and in a datagrid. The two fields in the dbase table are "empDate" and "time_in_Service". I have tried using the DateDiff function but Access cannot recognize the field name ("empDate") in the function. How do I calculate the months of service as the default value in the "time_in_Service" field based on the current date and a reference to the "empDate" field? Any Suggestions? Thanks
• • Reply
  

  douglas.reil...

  All-Star

  23315 Points

  4647 Posts

  Re: Calculating Months Between Two Dates in Access?

  Oct 08, 2003 11:11 PM|LINK

  Now() should work, I think.
  Starting with ASP.NET 2.0? Look at:
  Programming Microsoft Web Forms
  My Blog
• • Reply
  

  autofed

  Participant

  1789 Points

  357 Posts

  Re: Calculating Months Between Two Dates in Access?

  Oct 11, 2003 09:16 PM|LINK

  Assuming the "time_in_Service" is supposed to be relative to the current date, how can you store it in a table? Each time you access the data, the current date will be different. The appropriate way to display this data is to retrieve the empDate, then calculate the TimeInService in your code. AutoFed
• • Reply
  

  ronba

  Member

  375 Points

  75 Posts

  Microsoft

  Re: Calculating Months Between Two Dates in Access?

  Oct 14, 2003 06:47 PM|LINK

  Here's an example using the Northwind Employees table... SELECT Employees.HireDate, DateDiff("m",[HireDate],Now()) AS time_in_Service FROM Employees;