how we will find difference between two dates in MS Acess

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How we will find the difference between two date columns and difference will
appear in third column.
 
How we will find the difference between two date columns and difference will
appear in third column.
Click to expand...

In a query?
DaysDifference:DateDiff("d",[DateField1],[DateField2])
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difference in dates/times within same column grouped by individual 4
Date subtraction 1
Pivot table macro filter data between yesterday and today (date+time) 0
Excel Comparing two columns 1
Excel Help with dates 2
Can MS Acess be linked to an Excel worksheet? 8
Date search query 0
Power Pivot Variance Column 0

Back
Top