Results 1 to 4 of 4

how i can express today date in calculated field in table

  1. #1
    newegyptian is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Mar 2019
    Posts
    46

    how i can express today date in calculated field in table

    how i can express today date in calculated field in table



    Attached Thumbnails Attached Thumbnails LPL.jpg   JKIK.jpg  

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,224
    Can't. Why would you need to have field that is just the current date?
    Last edited by June7; 06-18-2019 at 05:01 AM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Ajax is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    7,548
    you can set the default value to date() or now() - which will automatically populate when the record is created - which may meet your needs.

  4. #4
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,436
    Shouldn't use calculated FIELDS in tables!
    Calculations are better done in queries.

    Also should stay away from Look up FIELDS and Multi-value FIELDS in tables.
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 02-15-2017, 06:07 PM
  2. Calculated Field: Today() - [DOS]
    By mrmmickle1 in forum Access
    Replies: 9
    Last Post: 08-10-2015, 03:50 PM
  3. Replies: 3
    Last Post: 12-04-2012, 05:22 PM
  4. Replies: 5
    Last Post: 10-12-2012, 11:00 AM
  5. Replies: 7
    Last Post: 07-12-2012, 02:35 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums