Go Back   Access World Forums > Microsoft Access Reference > Code Repository

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-28-2013, 09:10 AM   #1
Rx_
Nothing In Moderation
 
Rx_'s Avatar
 
Join Date: Oct 2009
Location: Denver, Colorado
Posts: 2,800
Thanks: 636
Thanked 337 Times in 307 Posts
Rx_ has a spectacular aura about Rx_ has a spectacular aura about Rx_ has a spectacular aura about
Lightbulb TIPS Excel and Access VBA, Data Type Time Date Tips

Yes, this is very Excel centered. But, so much of this relates to MS Access.
Over the last few weeks, there have been many questions about the basics of Dates and Time.
It would seem that many beginners have yet to learn that the Date is an illusion (at happy hour doubly so). The Date and Time are little more than a number.

The concept of taking Now() + 7 to transport to next week doesn't require a degree in quantum mechanics and a CERN particle accelerator.

This is easy to read, well laid out, and offers a little something for almost anyone.

http://chandoo.org/wp/2013/10/17/excel-date-time-tips/

__________________
Were you lucky enough to get an answer? Please mark your question as [SOLVED] The original poster can go to Thread Tools to mark it as Solved.

Quotation Thomas Jefferson: "Peace is that brief glorious moment in history when everybody stands around reloading."

There are 2 Kinds of Countries on this Planet
1. Those that use the Metric System
2. Those that had a man walk on the moon

Denver, Colorado - The "Mile High City" - non-metric!
Rx_ is offline   Reply With Quote
Reply

Tags
datatype , date , numeric , time , tips

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need tips on importing SQL table into Access (VBA or Macro) gilinnc Modules & VBA 7 07-30-2012 03:10 PM
VBA Performance Tips for Access Rx_ Modules & VBA 1 07-26-2010 09:57 AM
Random Tips & Tricks for Access and/or VBA Banana General 3 06-17-2008 05:51 PM
Tips needed: Access Books, Graphs, PDF antifashionpimp General 3 06-27-2005 05:02 AM
Req tips on a Consecutive Number generator access 97 TIDMAN General 5 11-23-2004 01:44 PM




All times are GMT -8. The time now is 08:39 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World