Results 1 to 2 of 2

Thread: DOB Query

  1. #1
    Join Date
    Sep 2010
    Posts
    14

    Unanswered: DOB Query

    Hi I have a query which using expression builder says

    =now() - DOB/365.25

    which takes account of the leap year. But it comes up with for example 36.123456789

    how can I get it to round up and get rid of the numbers after the decimal place?

    thanks
    Last edited by Glenthorne; 02-21-11 at 08:22. Reason: sorted it out thanks - please ignore

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You could try: =CInt(now() - DOB/365.25)
    Have a nice day!

Tags for this Thread

Posting Permissions

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