+ Reply to Thread
Results 1 to 12 of 12

DTPicker default value change to current date

Hybrid View

Lalie DTPicker default value change... 11-08-2013, 08:50 AM
alansidman Re: DTPicker default value... 11-08-2013, 09:14 AM
Lalie Re: DTPicker default value... 11-11-2013, 01:52 AM
:) Sixthsense :) Re: DTPicker default value... 11-11-2013, 01:56 AM
Lalie Re: DTPicker default value... 11-11-2013, 03:16 AM
  1. #1
    Registered User
    Join Date
    11-08-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    11

    DTPicker default value change to current date

    Hi

    I can not get my DTPicker to change the default value to the current day. I read through all the posts i could find and did all the recommended changes. I still can't fix it. It keeps on giving the date that I inserted the DTPicker.

    If there is an easier method on to entering time into a cell.

    Please advise

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,754

    Re: DTPicker default value change to current date

    If you are looking to enter today's date then Control + ;
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    11-08-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: DTPicker default value change to current date

    Thanks for the help. I could not get it to work with Control +; so i just subtracted the creation date from the current date and added the number of days to the output cell.

    I know this is a stupid solution but it works.

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: DTPicker default value change to current date

    Why not Now() function

    =NOW()

    =TEXT(NOW(),"HH:MM:SS")


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  5. #5
    Registered User
    Join Date
    11-08-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: DTPicker default value change to current date

    What I want from the DTPicker is just the time entered with the current date. It is for automation purposes for log sheets. I don't want the current time as well since the operators can be a bit late and I want them to enter the time. If i use the now function it gives the current time and date.

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: DTPicker default value change to current date

    Then why not simply Ctrl+Shift+Semicolon

+ 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. Replies: 10
    Last Post: 08-01-2013, 11:40 AM
  2. Default to most current date in Pivot Filter
    By camdameron in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2013, 08:49 AM
  3. how to change default font in current worksheet only
    By WarrenC in forum Excel General
    Replies: 2
    Last Post: 05-28-2008, 04:18 PM
  4. [SOLVED] Using DTPicker to change date in a cell when user selects cell?
    By WaterDog in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-08-2006, 09:20 AM
  5. [SOLVED] excel change default column sort to current selection
    By john palmer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-08-2005, 12:06 PM

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