Writing Rule With Date Function

Sort:
You are not authorized to post a reply.
Author
Messages
Dennis Amory
Basic Member
Posts: 10
Basic Member
    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
      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
        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
          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
            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.