Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

counting days between 2 dates

Status
Not open for further replies.
paulminne

paulminne

Programmer
Nov 27, 2002
80
AU
Hi,

I was just wondering if there is a way to count the number of days in between 2 dates in the 'medium date' format? If so, where/how might I begin to code this?

Regards,

- Paul
 
Sort by date Sort by votes
Paul, Date/Time values are stored as Integers and decimals no matter what the format you choose so you should be able to use the DateDiff() function.
DateDiff("d",FirstDate, SecondDate)

That's all it should take.

Paul
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Locked
  • Question
switch between two open database
Replies
12
Views
848
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
3K
Andrzejek
Andrzejek
M
  • Locked
  • Question
Error 2004
Replies
2
Views
231
lameid
lameid
Moss100
  • Locked
  • Question
Upgrading from Access 2013 - whats the best option
Replies
2
Views
2K
Moss100
Moss100
LondonJohn
  • Locked
  • Question
Problem using Access 2003 and 2007 for the same database
Replies
4
Views
333
LondonJohn
LondonJohn

Part and Inventory Search

Sponsor

Back
Top