bcgov / bcgov/entity

Foundation date for converted coops

Open
#12,818 3 comments 0 reactions 0 assignees View on GitHub
bug ENTITY - DO NOT USE Priority2
Dominant language
JavaScript
Stars
23
Forks
62
Avg merge
24m
Merged PRs (30d)
1

Description

**Describe the bug in current situation**
As discussed,
**The foundation date in COBRS for coops converted from COBRS is 1 day ahead of the foundation date in the modernized coop application.**

- [ ] - Fix the code
- [ ] - Apply data fixes to existing records

David Roberts raised this issue with me, (David M.), can you check it and raise the appropriate ticket?
The problem is that when we converted all the dates to UTC, the date/time in UTC is 2006-11-20 16:00 whereas the date on the mainframe is 2006-11-21 00:00.

Thanks,

Dave

![image.png](https://images.zenhubusercontent.com/62741a399202cf3570f9fd40/57397867-2873-4274-845a-ce6b001f3802)![image.png](https://images.zenhubusercontent.com/62741a399202cf3570f9fd40/40266c9c-f288-47fe-8833-0eb49cea82a7)

**Link bug to the User Story**

**Impact of this bug**
Describe the impact, i.e. what the impact is, and number of users impacted.

**Chance of Occurring (high/medium/low/very low)**

**Pre Conditions: which Env, any pre-requesites or assumptions to execute steps?**

**Steps to Reproduce**
Steps to reproduce the behavior:
1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

**Actual/ observed behavior/ results**

**Expected behavior**
A clear and concise description of what you expected to happen. Use the gherking language.

**Screenshots/ Visual Reference/ Source**
If applicable, add screenshots to help explain your problem. You an use screengrab.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by comparing the foundation date in COBRS with the modernized coop application for converted coops, using the 2006-11-20 UTC and 2006-11-21 mainframe example. Determine where the UTC conversion affects the date, then identify the required code change and data fixes; done means existing and future records show the correct foundation date.

Written by the indexing model from the issue text.

Assessment

Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.