Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    BECCLES, Suffolk, England
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm using WXpHe and Office 2003.
    A general date query really, looking to create a general letter report with a default date of today. In the table I show that the default value is today. When the letter is written from a form the date is shown as today. So far no problems. When I view that letter tomorrow ill the date show as today or tomorrow please?
    <IMG SRC=http://www.wopr.com/w3tuserpics/StephenElms_sig.jpg> Didn't think that I made my first post here on 5th February 2001...!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    If the default value of the field is Date(), the field will be filled with the current date when a new record is created, but the value won't change automatically after that. The user can edit the value, of course.
    So unless the user does so, the field will still show today's date when viewed tomorrow.

    If you create a calculated column in a query:

    TheDate: Date()

    or if you create a text box with a formula =Date() as control source, it'll always display the current date: May 19 as I write, May 20 tomorrow, etc.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    BECCLES, Suffolk, England
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Many thanks indeed Hans. Just the info' I needed.
    <IMG SRC=http://www.wopr.com/w3tuserpics/StephenElms_sig.jpg> Didn't think that I made my first post here on 5th February 2001...!

Posting Permissions

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