Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2005
    Posts
    22

    Unanswered: Using the function: Today()

    Hello there, I need a little assistance please.

    Can "Today()" be used in a QBE or a Report? I am trying to use it in order to find the number of years an employee or a group of employees worked. I tried using 'example elements' in a query to no avail.

    Something like: "(today() - Employee's Employment date)/ 365.25"

    I can copy the data to a spreadsheet and get a result, but this not what I need.

  2. #2
    Join Date
    Dec 2007
    Posts
    366
    in QBE, the word today without the parens.. in reports, functions work with the parens..
    --
    Steven Green - Myrtle Beach, South Carolina USA

    http://www.OasisTradingPost.com

    Oasis Trading Post
    - Collectibles and Memorabilia
    - Vintage Lego Sets and Supplies
    - and Paradox Support, too

  3. #3
    Join Date
    Jan 2005
    Posts
    22

    Thank you

    Thank you very much brother Greene. However, I gave it a shot and I am back at 'square one'.

    I really need some guidance on this one.

  4. #4
    Join Date
    Dec 2007
    Posts
    366
    the few remaining long-time paradox developers hang out at Home - Paradox Community, not here.. that's why I keep telling everyone to post there..
    --
    Steven Green - Myrtle Beach, South Carolina USA

    http://www.OasisTradingPost.com

    Oasis Trading Post
    - Collectibles and Memorabilia
    - Vintage Lego Sets and Supplies
    - and Paradox Support, too

  5. #5
    Join Date
    May 2007
    Posts
    31
    I don't know if this would help any but I've had some success in by using statements like this is...

    (DatePart("yyyy",Date())-DatePart("yyyy",[Birthdate]))-1

    Which in this example is taking today's year and subtracting the year of the birthday...

    Hope this triggers an idea for you

Posting Permissions

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