+ Reply to Thread
Results 1 to 4 of 4

Pop Up Calendar issue with 2030 vs 1930

  1. #1
    Forum Contributor
    Join Date
    05-28-2016
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    106

    Pop Up Calendar issue with 2030 vs 1930

    I have been using some VBA code borrowed from the internet to allow me to select dates from a pop-up calendar.
    No matter how I formate the destination cell or make changes to Windows regional settings, any dates from the year 2010 and over are displayed as 1930, etc.
    Any suggestions on how to overcome this? I suspect it has something to do with the VBA which I am too much of a novice to work out. Thanks in advance.
    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    2016
    Posts
    532

    Re: Pop Up Calendar issue with 2030 vs 1930

    Hi, I'm only very novice with vba, but maybe try applying the format when settting ThisDay.
    e.g. ThisDay = Format(Date, "yyyy/mm/dd")

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,494

    Re: Pop Up Calendar issue with 2030 vs 1930

    See if this clarifies the issue: https://docs.microsoft.com/en-us/off...t-year-numbers
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Contributor
    Join Date
    05-28-2016
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    106

    Re: Pop Up Calendar issue with 2030 vs 1930

    Thanks. I checked the code thoroughly and changed every instance of yy to yyyy and this finally worked. I should have known this from the start.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Julian year 2030 conversion
    By omayes in forum Excel General
    Replies: 11
    Last Post: 03-26-2017, 05:47 PM
  2. Calendar Issue
    By dataman22 in forum Excel General
    Replies: 3
    Last Post: 11-12-2014, 12:32 PM
  3. AddSheet Calendar Macro Issue
    By nauti in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-23-2009, 06:24 AM
  4. Calendar issue
    By Link in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-09-2008, 05:21 AM
  5. Finding day of week in 2030
    By Lisa Clamors in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-18-2006, 06:15 PM
  6. [SOLVED] Calendar issue
    By cjtj4700 in forum Excel General
    Replies: 2
    Last Post: 01-06-2006, 04:25 PM
  7. [SOLVED] Datevalue if born before 1930
    By Frank Malone in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-12-2005, 11:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1