× Discuss about Archiving, Close of Business, Delivery Setup, Security Management System, Global Processing etc…

Capture COB running date

Start
Prev
1
Next
End

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.

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

6 years 3 weeks ago #22011 by VK

Replied by VK on topic Capture COB running date

See the example below:

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.

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

6 years 3 weeks ago #22013 by 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.

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

6 years 3 weeks ago #22015 by 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.

Start
Prev
1
Next
End

Time to create page: 0.084 seconds