Prev
Next
Forums Integration / Customization S3 Interfaces/Conversion

Writing Rule With Date Function

 4 Replies
 0 Subscribed to this topic
 11 Subscribed to this forum
Sort:
Author
Messages
Dennis Amory
Basic Member
Posts: 10
Basic Member
4/24/2013 3:16 PM
    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
    Veteran Member
    Posts: 52
    Veteran Member
    4/24/2013 6: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
      Basic Member
      Posts: 10
      Basic Member
      4/25/2013 12:06 PM
        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
        Veteran Member
        Posts: 52
        Veteran Member
        4/25/2013 12:54 PM
          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
          Basic Member
          Posts: 10
          Basic Member
          4/30/2013 8:46 PM
            Yea, hopefully it would be addressed soon. I imagine it is frustrating to more than a few users. Lol.