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

Capture COB running date

  • yoshan
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
  • Posts: 73
  • Thank you received: 0

yoshan created the topic: Capture COB running date

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.
#22009

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 672
  • Thank you received: 97

VK replied the 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
#22011

Please Log in or Create an account to join the conversation.

  • yoshan
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
  • Posts: 73
  • Thank you received: 0

yoshan replied the 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.
#22012

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 672
  • Thank you received: 97

VK replied the 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
#22013

Please Log in or Create an account to join the conversation.

  • yoshan
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
  • Posts: 73
  • Thank you received: 0

yoshan replied the 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.
#22014

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 672
  • Thank you received: 97

VK replied the 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
#22015

Please Log in or Create an account to join the conversation.

  • Posts: 106
  • Karma: 2
  • Thank you received: 7

MasterL replied the 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.
#22019

Please Log in or Create an account to join the conversation.

Time to create page: 1.643 seconds