• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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.