PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 04/30/2013 4:46 PM by  Dennis Amory
Writing Rule With Date Function
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Dennis Amory
Security Administrator
Greenville County Schools
Basic Member
(20 points)
Basic Member
Posts:10


Send Message:

--
04/24/2013 11:16 AM
    I am writing a security rule that uses the date util functions dateFormat( ) and dateDiff( ). The rule is successful if I enter a hardcoded date in the function (such as '20051130' or '04/24/2013'), but not if I enter the field from a form (such as form.TRD_TR_DATE). Any idea how to fix this?
    Georgette
    Financial Systems Coord
    MRHS
    Veteran Member
    (152 points)
    Veteran Member
    Posts:52


    Send Message:

    --
    04/24/2013 2:43 PM
    Hi Dennis,
    You don't state what version of Lawson you are using but came across this in the KnowledgeBase for LSA, article 5420594.
    This is a known issue with the dateDiff security function. The problem ticket is JT-140225.

    The fix for this issue is not yet available. The workaround is to use a hard coded date in the rule.
    Dennis Amory
    Security Administrator
    Greenville County Schools
    Basic Member
    (20 points)
    Basic Member
    Posts:10


    Send Message:

    --
    04/25/2013 8:06 AM
    Georgette - I appreciate your providing me with that info. I was also able to find the KB on it. BTW, I'm using version 9.0.2. I guess I will have to figue out a workaround. Thanks again!!
    Georgette
    Financial Systems Coord
    MRHS
    Veteran Member
    (152 points)
    Veteran Member
    Posts:52


    Send Message:

    --
    04/25/2013 8:54 AM
    Glad I remembered seeing that in my research. There is nothing worse than beating your head on the wall over simple code that should work.

    Perhaps Infor will provide a CTP in the near future to correct the error.
    Dennis Amory
    Security Administrator
    Greenville County Schools
    Basic Member
    (20 points)
    Basic Member
    Posts:10


    Send Message:

    --
    04/30/2013 4:46 PM
    Yea, hopefully it would be addressed soon. I imagine it is frustrating to more than a few users. Lol.
    You are not authorized to post a reply.