×
Discuss about Archiving, Close of Business, Delivery Setup, Security Management System, Global Processing etc…
Capture COB running date
- yoshan
- Topic Author
- Visitor
-
6 years 3 weeks ago #22009
by yoshan
Capture COB running date was created by yoshan
Mates,
Hopes everyone doing well!
When COB started there were two records updating for each company in Date table and during SOD both reset and matched.
Which filed and table I can consider as a SYSTEM date (Today value before COB starting) through out the COB, until it finished.
Hopes everyone doing well!
When COB started there were two records updating for each company in Date table and during SOD both reset and matched.
Which filed and table I can consider as a SYSTEM date (Today value before COB starting) through out the COB, until it finished.
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
Less
More
- Posts: 1202
- Thank you received: 158
6 years 3 weeks ago #22011
by VK
Cheers
VK
Replied by VK on topic Capture COB running date
See the example below:
... so you can rely on LAST.WORKING.DAY in "xx0010001" record.
Before COB, today = 20/2/2019:
@ID............ LAST.WORKING.DAY TODAY...... NEXT.WORKING.DAY
xx0010001 20190219 20190220 20190221
xx0010001-COB 20190219 20190220 20190221
COB started:
@ID............ LAST.WORKING.DAY TODAY...... NEXT.WORKING.DAY
xx0010001 20190220 20190221 20190222
xx0010001-COB 20190219 20190220 20190221
COB finished:
@ID............ LAST.WORKING.DAY TODAY...... NEXT.WORKING.DAY
xx0010001 20190220 20190221 20190222
xx0010001-COB 20190220 20190221 20190222
... so you can rely on LAST.WORKING.DAY in "xx0010001" record.
Cheers
VK
Please Log in or Create an account to join the conversation.
- yoshan
- Topic Author
- Visitor
-
6 years 3 weeks ago #22012
by yoshan
Replied by yoshan on topic Capture COB running date
Hello VK,
Thanks your quick response.
But my requirement is from before COB start to COB end how we extract current COB date.
Thanks your quick response.
But my requirement is from before COB start to COB end how we extract current COB date.
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
Less
More
- Posts: 1202
- Thank you received: 158
6 years 3 weeks ago #22013
by VK
Cheers
VK
Replied by VK on topic Capture COB running date
Before COB it's in TODAY field; when the COB is started it's in LAST.WORKING.DAY as I described... Otherwise I don't understand what you need...
Cheers
VK
Please Log in or Create an account to join the conversation.
- yoshan
- Topic Author
- Visitor
-
6 years 3 weeks ago #22014
by yoshan
Replied by yoshan on topic Capture COB running date
Thank you,
Requirement is simple, extract today date value before the COB start till COB end. Dates table changing during SOD, so I cannot take from F.DATE table.
Requirement is simple, extract today date value before the COB start till COB end. Dates table changing during SOD, so I cannot take from F.DATE table.
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
Less
More
- Posts: 1202
- Thank you received: 158
6 years 3 weeks ago #22015
by VK
Cheers
VK
Replied by VK on topic Capture COB running date
Solution is also simple: create a COB job that runs as early as possible and save somewhere LAST.WORKING.DAY contents of "xx0010001" record.
Cheers
VK
Please Log in or Create an account to join the conversation.
- MasterL
- Visitor
-
6 years 2 weeks ago #22019
by MasterL
Replied by MasterL on topic Capture COB running date
I also don't really get the requirement but as @VK explained, the dates you need are in the the date table. If you are using the routine, use R.DATES common variable. If you are going to run the routine as part of COB you need to remember that T24 will cycle date at start of COB. Therefore TODAY date value will have been pushed to the next day (again, please refer to the illustration by VK). So you need to use the LAST.WORKING.DAY value.
Please Log in or Create an account to join the conversation.
Time to create page: 0.087 seconds