Results 1 to 5 of 5
  1. #1
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528

    age and day - month - year

    Hello Guys During the search in the forum and found this (DB) to calculate the age. Very nice
    Question
    How do I know when / or such date (day - month - year) that person becomes 60 years old Example 40 year-old John of today's date, in the history (21/08/2034) will become 60 years old I want to see how this date in Text16
    Thanks in advance
    Attached Files Attached Files

  2. #2
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,044
    Use the dateadd(<interval>,<number>,<date>) function to add an interval (years, months, ....) to a given date

  3. #3
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Thank you very much NoellaG
    Is it possible to view attachments
    How so, I could not calculate the difference.

  4. #4
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,044

    Use dateadd

    Hi,

    I added a new form to the zipped database that shows how you can use the dateadd function
    Attached Files Attached Files

  5. #5
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Thank you very much NoellaG
    Dear smart cat

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

Similar Threads

  1. Replies: 4
    Last Post: 05-26-2013, 03:28 PM
  2. Year to DATE by Month
    By lugnutmonkey in forum Queries
    Replies: 1
    Last Post: 01-18-2013, 05:37 PM
  3. Sum by Won Project in by each month of the year
    By 011billyw in forum Reports
    Replies: 11
    Last Post: 03-22-2012, 04:09 PM
  4. Sorting by month and day - without year
    By TracyBell in forum Access
    Replies: 3
    Last Post: 11-17-2011, 10:29 AM
  5. by year by month
    By nkuebelbeck in forum Reports
    Replies: 21
    Last Post: 03-24-2010, 01:53 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
  •  
Other Forums: Microsoft Office Forums