I'm not familiar with SQL or anything, and I was wondering if there is a way in Microsoft Access to do date calculations... ex: 6-14-01, how many days till the end of the month.. so the calculation would be something like 7/01/01 - 6-14-01 = amount of days till end of month
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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need help with date calculations in access... 1
- Thread starter Savale
- Start date
-
1
- #2
PhilipSchroevers
Programmer
Check out the DateDiff, DateAdd and DateSerial functions in the Access Help. They'll solve your problem (and many more)!
- Status
Similar threads
- Locked
- Question