|
View previous topic :: View next topic
|
| Author |
Message |
pradeepkumarrk
New User
Joined: 17 Oct 2005
Posts: 2
|
|
|
|
| How to get the last saturday date in the job by using control-m variables. Irrespective of the day job runs. |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
Recently asked.
Look HERE |
|
| Back to top |
|
|
pradeepkumarrk
New User
Joined: 17 Oct 2005
Posts: 2
|
|
|
|
Expat,
I ran the job with the data mentioned in the topic.
Job is setting up LASTSAT DATE as 22-JAN-09 which is wrong. It has to set last saturday as 24-jan-09.
| Code: |
//* %%SET %%CURRENT = %%SUBSTR %%DATE 1 1
//* %%IF %%CURRENT EQ 9
//* %%SET %%CENT = 19
//* %%ELSE
//* %%SET %%CENT = 20
//* %%ENDIF
//* %%SET %%DX1 = %%CALCDATE %%ODATE -6
//* %%SET %%DM1 = %%SUBSTR %%DX1 3 2
//* %%SET %%DD1 = %%SUBSTR %%DX1 5 2
//* %%SET %%DY1 = %%SUBSTR %%DX1 1 2
//* %%SET %%LASTSAT = %%DY1%%.%%DM1%%.%%DD1 |
|
|
| Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006
Posts: 1702
Location: Australia
|
|
|
|
Hi,
the above code will only work when the job is scheduled with Friday's ODATE.
You can try this
| Code: |
//* %%IF %%OWDAY EQ 1
//* %%SET %%OPRV_SAT = %%CALCDATE %%ODATE -1
//* %%ENDIF
//* %%IF %%OWDAY EQ 2
//* %%SET %%OPRV_SAT = %%CALCDATE %%ODATE -2
//* %%ENDIF
//* %%IF %%OWDAY EQ 3
//* %%SET %%OPRV_SAT = %%CALCDATE %%ODATE -3
//* %%ENDIF
//* %%IF %%OWDAY EQ 4
//* %%SET %%OPRV_SAT = %%CALCDATE %%ODATE -4
//* %%ENDIF
//* %%IF %%OWDAY EQ 5
//* %%SET %%OPRV_SAT = %%CALCDATE %%ODATE -5
//* %%ENDIF
//* %%IF %%OWDAY EQ 6
//* %%SET %%OPRV_SAT = %%CALCDATE %%ODATE -6
//* %%ENDIF
//* %%IF %%OWDAY EQ 0
//* %%SET %%OPRV_SAT = %%CALCDATE %%ODATE -7
//* %%ENDIF
|
Please note that 1 is used for Sunday, 2 is for Monday and so on in my shop.
Gerry |
|
| Back to top |
|
|
|
|
