Author |
Message |
mpadilla
Joined: 02 Jul 2008 Posts: 33
|
|
JAL Macro Parameters Usage (Error?) |
|
Hello,
I am trying to use the macro parameters to gather the last business date to use in a script (JAL).
In the past, using @DL I would get directly the last business date.
Now, when I am using @DL, I am getting the last calendar date.
I was expecting on a Monday, using @DL to get Friday's date. Instead I am getting Sunday's date.
Any suggestions?
|
|
Mon Sep 29, 2014 9:27 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
What does JAL IsHoliday function return on that system for last Sunday? Or does it return an error?
Dim ret, boolean
IsHoliday "2014-09-28", ret
MessageBox ret
|
|
Wed Oct 01, 2014 12:17 am |
|
![](templates/GreenTech/images/spacer.gif) |
mpadilla
Joined: 02 Jul 2008 Posts: 33
|
|
|
|
![](templates/GreenTech/images/quote_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
What does JAL IsHoliday function return on that system for last Sunday? Or does it return an error?
Dim ret, boolean
IsHoliday "2014-09-28", ret
MessageBox ret |
Responds with "FALSE"
|
|
Wed Oct 01, 2014 11:35 am |
|
![](templates/GreenTech/images/spacer.gif) |
mpadilla
Joined: 02 Jul 2008 Posts: 33
|
|
|
|
Any updates on this?
This item is not isolated to one server. We have two different instances installed in two different servers and both of them present the same behavior.
|
|
Fri Oct 03, 2014 8:24 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
No updates yet. We were able to reproduce the issue but the root cause is yet unknown. Some kind of weird anomaly.
As a workaround, please use for now
![](templates/GreenTech/images/code_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
Dim d, date, "@T"yyyy-mm-dd""
Dim b, boolean
IsWeekEnd d, b
LoopWhile b, EndLoop
DateAdd d, -1, d
IsWeekEnd d, b
EndLoop:
MessageBox d |
|
|
Fri Oct 03, 2014 12:54 pm |
|
![](templates/GreenTech/images/spacer.gif) |
mpadilla
Joined: 02 Jul 2008 Posts: 33
|
|
|
|
Thanks for the work around.
What is the ETA for a permanent solution?
We have about 50 jobs that use the @DL keyword, so implementing the workaround on each one of them would be time consumming.
|
|
Mon Oct 06, 2014 11:38 am |
|
![](templates/GreenTech/images/spacer.gif) |
mpadilla
Joined: 02 Jul 2008 Posts: 33
|
|
|
|
The "IsHoliday" statement does not work.
It returns false for all holidays that exists in the calendar. (I added the same date to all calendars, not only to the one that was assigned to the job).
Any workaround to verify the holiday???
|
|
Thu Nov 06, 2014 5:11 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
Hi. We expect a fix for this issue release by the end of the week.
|
|
Mon Nov 10, 2014 11:57 am |
|
![](templates/GreenTech/images/spacer.gif) |
mpadilla
Joined: 02 Jul 2008 Posts: 33
|
|
|
|
Any news on the patch for this issue?
|
|
Fri Nov 21, 2014 4:50 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
Hello. Yes a fix is available. Please email to support and request download link for version 5.2.420
|
|
Tue Nov 25, 2014 1:54 am |
|
![](templates/GreenTech/images/spacer.gif) |
|