Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel VBA System Date Help


  • Please log in to reply

#1
notquiteanexpert

notquiteanexpert

    Member

  • Member
  • PipPip
  • 17 posts
Hi Guys,

I want to get the actual current date in Excel or VBA. Obviously, if I just use today() or now() I get the current system date. This doesn't work for me because I want to userproof the fact that users can easily change the system date.

Does anyone have some code that I can use to somehow get the correct date, irrespective of what is set as the system date in Windows??

Thanks heaps.
  • 0

Advertisements


#2
TheQuickBrownFox

TheQuickBrownFox

    Member

  • Member
  • PipPipPip
  • 714 posts
Based on my experience (which isn't much! :) ) all date functions refer to the system clock one way or another, IMO.
  • 0

#3
Metallica

Metallica

    Spyware Veteran

  • GeekU Moderator
  • 32,942 posts
Just to show that (*in theory) it is possible:
http://www.worldtime...ime_zone_guide/
but at $ 400 per year this one might be a bit too much. :)
  • 0

#4
TheQuickBrownFox

TheQuickBrownFox

    Member

  • Member
  • PipPipPip
  • 714 posts
:)
  • 0

#5
Ax238

Ax238

    Tech Staff

  • Technician
  • 1,323 posts
If the user is connected to the Internet, you can use the approach outlined in the following page:
VB Helper: HowTo: Set the computer's time using the NIST atomic clock

Ax
  • 0

#6
notquiteanexpert

notquiteanexpert

    Member

  • Topic Starter
  • Member
  • PipPip
  • 17 posts
No worries. I'll just have to rely on the system date then....

Thanks guys.
  • 0

#7
Ax238

Ax238

    Tech Staff

  • Technician
  • 1,323 posts
:) No problem
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP