Results 1 to 4 of 4

Thread: Paradox Report

  1. #1
    Join Date
    Jun 2011
    Posts
    2

    Unanswered: Paradox Report

    Hi!
    1) Excuse me for my english!
    2) I must prepare a formula in a field in paradox report that show number "23" if the date of a record (:Tables:comm.Comm_dt_aper) is < "31/12/2010", else shows "24". What can I do to make this?

    Thank you very much for all the answers!

  2. #2
    Join Date
    Dec 2007
    Posts
    366
    [my field] = IIF( (:Tables:comm.Comm_dt_aper) < "31/12/2010", "23" , "24" )

    your example, as shown, might not work correctly without DATEVAL() or other similar conversion
    --
    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
    Jun 2011
    Posts
    2
    Quote Originally Posted by Steve Green View Post
    [my field] = IIF( (:Tables:comm.Comm_dt_aper) < "31/12/2010", "23" , "24" )

    your example, as shown, might not work correctly without DATEVAL() or other similar conversion
    Where can I fill the DATEVAL? Before Comm_dt_aper and/or 31/12/2010 doesn't works...

    = IIF( (:Tables:comm.Comm_dt_aper) < DATEVAL(31/12/2010), "23" , "24" )

  4. #4
    Join Date
    Dec 2007
    Posts
    366
    I do not what any of your field types are, I do not know what your variables types are, I do not know what version of paradox you are using, I do not know what your error message is, etc, etc, etc.. my example was just an example to give you ideas.. if you supply much more detail, and post your message on the "paradox community" forum, you can get some great help..

    Home - Paradox Community

    go to support, then go to newsgroups..
    --
    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

Posting Permissions

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