+ Reply to Thread
Results 1 to 8 of 8

Current Date problem

  1. #1
    Registered User
    Join Date
    01-04-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    67

    Current Date problem

    Hello,

    I need advice for a problem I keep having in Excel, we run an order system and I am trying to make it as user friendly as possible.

    When the sheet opens I want it to automatically insert the date in to the box in the format dd.mm.yy - which i can do with =Today().

    However if i open the file tomorrow the file has changed date to its current date.

    Could someone please help me to stop this happening for once the date is set?

    Thank you
    darren

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Current Date problem

    Darren, welcome to the board though please note we have a few Q&A forums and ask you post in the most appropriate to your question.

    I've moved your thread from Outlook to Excel Programming Forum where you should get a suitable response.

    (you could do this with formulae [iteration] but I wouldn't advise it)

  3. #3
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Current Date problem

    Quote Originally Posted by cafc_fuller View Post
    Hello,

    However if i open the file tomorrow the file has changed date to its current date.
    This is unclear (at least to me), don't you want the date to refresh with each new day?
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  4. #4
    Registered User
    Join Date
    01-04-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    67

    Re: Current Date problem

    Sorry -

    Once I open the file I want the date to set to the current date automatically. If i then re-open it the following day i would like it to still display the date from yesterday.

    Is that clearer?

    Thank you once again

  5. #5
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Current Date problem

    Depending on your workbook structure, you would need to add either another row or column for the new date. Mayhap if you could upload a mock workbook so that we could see the structure, and then create the code accordingly.

  6. #6
    Registered User
    Join Date
    01-04-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    67

    Re: Current Date problem

    Please see the attached sheet - the very first date box is the one which i want the current date to be automatically entered into. Then not change the following day.

    Thank you
    Attached Files Attached Files

  7. #7
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Current Date problem

    I've looked at your form and have at least 1 area of concern. If we write code to insert today's date, it will always insert the current date into that cell. I think we could modify the code to keep the original date but we would have to base the modification of something unique, the order number perhaps. What do you think? Basically, you want the current date to be entered only if there is a new order, correct?

  8. #8
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Current Date problem

    You could try this:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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