[WT-8876] Date format rationalization - Workterra Jira

Details

Type: Enhancement
Status: In Development
Priority: Medium
Resolution: Unresolved
Affects Version/s: None
Fix Version/s: None
Component/s: BenAdmin
Labels:
None

Module:
BenAdmin - Import
Reported by:
Client
Item State:
Development - On Hold
Issue Importance:
Q2
Sprint:
WT Sprint 38 - Enhancement, WT Sprint 40 - Enhancement
Severity:
Simple

Description

Please refer to ~~WT-8848~~.

We support date formats - which appear to be redundant (see first two) and incomplete.
MM/DD/YYYY
MM-DD-YYYY
YYYY/MM/DD
YYYYMMDD

But not - which is one of the standard US date format.
MMDDYYYY

This date format picker needs to be rationalized to allow following regular expressions where * stands for any special character. In fact the list can be further pruned if the system could parse the string to remove special characters first and then we interpret it for only three options.
MM*DD*YYYY
MMDDYYYY
DD*MM*YYYY
DDMMYYYY
YYYY*MM*DD
YYYYMMDD

CC Nathaniel Cornejo-Walker Cindy Wibbing Nagini Indugula Bharti Satpute Amit Thorve

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

Testcases.xls
33 kB
13/Oct/17 06:57 AM

Issue Links

relates to

WT-8848 City National Bank import failure

Closed

Activity

Ascending order - Click to sort in descending order

Abhay Patil (Inactive) created issue - 15/Mar/17 08:53 PM

Abhay Patil (Inactive) made changes - 15/Mar/17 08:55 PM

Field	Original Value	New Value
Description	Please refer to ~~WT-8848~~. We support date formats - which appear to be redundant (see first two) and incomplete. MM/DD/YYYY MM-DD-YYYY YYYY/MM/DD YYYYMMDD But not - which is one of the standard US date format. MMDDYYYY This date format picker needs to be rationalized to allow following regular expressions where * stands for any special character. MMDDYYYY MMDDYYYY DDMMYYYY DDMMYYYY YYYYMMDD YYYYMMDD CC [~nwalker] [~Cindy.Wibbing] [~nagini.Indugula] [~bharti]	Please refer to ~~WT-8848~~. We support date formats - which appear to be redundant (see first two) and incomplete. MM/DD/YYYY MM-DD-YYYY YYYY/MM/DD YYYYMMDD But not - which is one of the standard US date format. MMDDYYYY This date format picker needs to be rationalized to allow following regular expressions where * stands for any special character. In fact the list can be further pruned if the system could parse the string to remove special characters first and then we interpret it for only three options. MMDDYYYY MMDDYYYY DDMMYYYY DDMMYYYY YYYYMMDD YYYYMMDD CC [~nwalker] [~Cindy.Wibbing] [~nagini.Indugula] [~bharti]

Abhay Patil (Inactive) made changes - 15/Mar/17 08:57 PM

Description

Please refer to ~~WT-8848~~.

We support date formats - which appear to be redundant (see first two) and incomplete.
MM/DD/YYYY
MM-DD-YYYY
YYYY/MM/DD
YYYYMMDD

But not - which is one of the standard US date format.
MMDDYYYY

*This date format picker needs to be rationalized to allow following regular expressions* where * stands for any special character. In fact the list can be further pruned if the system could parse the string to remove special characters first and then we interpret it for only three options.
MM*DD*YYYY
MMDDYYYY
DD*MM*YYYY
DDMMYYYY
YYYY*MM*DD
YYYYMMDD

CC [~nwalker] [~Cindy.Wibbing] [~nagini.Indugula] [~bharti]

Rakesh Roy (Inactive) made changes - 16/Mar/17 04:49 AM

Link

This issue relates to ~~WT-8848~~ [ ~~WT-8848~~ ]

Suraj Sokasane (Inactive) made changes - 16/Mar/17 06:47 AM

Assignee

Vijay Siddha [ vijays ]

Suraj Sokasane [ suraj.sokasane ]

Rakesh Roy (Inactive) made changes - 20/Mar/17 05:19 AM

Issue Importance

Good To Have [ 11802 ]

Q2 [ 14901 ]

Jaideep Vinchurkar (Inactive) made changes - 08/Sep/17 11:35 AM

Assignee

Suraj Sokasane [ suraj.sokasane ]

Vishal Bajad [ vishal.bajad ]

Gaurav Sodani (Inactive) made changes - 08/Sep/17 06:48 PM

Sprint

WT Sprint 37 - Enhancement [ 86 ]

Vishal Bajad (Inactive) made changes - 12/Sep/17 05:49 AM

Status

New Request [ 10029 ]

Pending for Approval [ 10002 ]

Vishal Bajad (Inactive) made changes - 12/Sep/17 05:50 AM

Status

Pending for Approval [ 10002 ]

Approved for Development [ 10003 ]

Vishal Bajad (Inactive) made changes - 12/Sep/17 05:50 AM

Status

Approved for Development [ 10003 ]

In Development [ 10007 ]

Vishal Bajad (Inactive) made changes - 12/Sep/17 05:51 AM

Dev Due Date		14/Sep/2017
Developer		Vishal Bajad [ vishal.bajad ]
Item State		Parent values: Development(10200)Level 1 values: In Analysis(10204)
QA		Jayshree Nagpure [ jayshree.nagpure ]

Vishal Bajad (Inactive) made changes - 12/Sep/17 12:59 PM

Remaining Estimate		0h [ 0 ]
Time Spent		2h [ 7200 ]
Worklog Id		78271 [ 78271 ]

Jaideep Vinchurkar (Inactive) made changes - 12/Sep/17 03:44 PM

Assignee

Vishal Bajad [ vishal.bajad ]

Abhay Patil [ abhay.patil ]

Jaideep Vinchurkar (Inactive) made changes - 12/Sep/17 03:44 PM

Time Spent	2h [ 7200 ]	3h [ 10800 ]
Worklog Id		78334 [ 78334 ]

Gaurav Sodani (Inactive) made changes - 14/Sep/17 12:54 PM

Item State

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Parent values: Development(10200)Level 1 values: On Hold(10207)

Gaurav Sodani (Inactive) made changes - 14/Sep/17 12:54 PM

Dev Due Date

14/Sep/2017

Abhay Patil (Inactive) made changes - 15/Sep/17 05:15 PM

Assignee

Abhay Patil [ abhay.patil ]

Jennifer Reed [ jennifer.reed ]

Abhay Patil (Inactive) made changes - 18/Sep/17 05:08 PM

Assignee

Jennifer Reed [ jennifer.reed ]

Jaideep Vinchurkar [ jaideep.vinchurkar ]

Gaurav Sodani (Inactive) made changes - 20/Sep/17 08:52 AM

Sprint

WT Sprint 37 - Enhancement [ 86 ]

Jaideep Vinchurkar (Inactive) made changes - 20/Sep/17 03:08 PM

Assignee

Jaideep Vinchurkar [ jaideep.vinchurkar ]

snehal katkar [ snehal.katkar ]

Gaurav Sodani (Inactive) made changes - 22/Sep/17 10:31 AM

Sprint		WT Sprint 38 - Enhancement [ 88 ]
Original Estimate		0h [ 0 ]

Jaideep Vinchurkar (Inactive) made changes - 26/Sep/17 11:39 AM

Dev Due Date

05/Oct/2017

Gaurav Sodani (Inactive) made changes - 27/Sep/17 12:07 PM

Item State

Parent values: Development(10200)Level 1 values: On Hold(10207)

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Jaideep Vinchurkar (Inactive) made changes - 28/Sep/17 07:35 AM

Original Estimate

0h [ 0 ]

28h [ 100800 ]

Snehal Katkar (Inactive) made changes - 29/Sep/17 10:16 AM

Developer

Vishal Bajad [ vishal.bajad ]

snehal katkar [ snehal.katkar ]

Jaideep Vinchurkar (Inactive) made changes - 29/Sep/17 04:48 PM

Time Spent	3h [ 10800 ]	3.5h [ 12600 ]
Worklog Id		82891 [ 82891 ]

Snehal Katkar (Inactive) made changes - 09/Oct/17 07:15 AM

Time Spent	3.5h [ 12600 ]	9.5h [ 34200 ]
Worklog Id		83835 [ 83835 ]

Snehal Katkar (Inactive) made changes - 09/Oct/17 07:34 AM

Time Spent	9.5h [ 34200 ]	11h [ 39600 ]
Worklog Id		83842 [ 83842 ]

Jayshree Nagpure (Inactive) made changes - 13/Oct/17 06:57 AM

Attachment

Testcases.xls [ 64417 ]

Jayshree Nagpure (Inactive) made changes - 13/Oct/17 06:59 AM

Time Spent	11h [ 39600 ]	15.5h [ 55800 ]
Worklog Id		84771 [ 84771 ]

Snehal Katkar (Inactive) made changes - 17/Oct/17 12:42 PM

Time Spent	15.5h [ 55800 ]	18.5h [ 66600 ]
Worklog Id		85423 [ 85423 ]

Snehal Katkar (Inactive) made changes - 17/Oct/17 12:43 PM

Time Spent	18.5h [ 66600 ]	21.5h [ 77400 ]
Worklog Id		85424 [ 85424 ]

Snehal Katkar (Inactive) made changes - 17/Oct/17 12:44 PM

Time Spent	21.5h [ 77400 ]	29.5h [ 106200 ]
Worklog Id		85425 [ 85425 ]

Snehal Katkar (Inactive) made changes - 17/Oct/17 12:44 PM

Time Spent	29.5h [ 106200 ]	37.5h [ 135000 ]
Worklog Id		85426 [ 85426 ]

Snehal Katkar (Inactive) made changes - 17/Oct/17 12:44 PM

Remaining Estimate	0h [ 0 ]	0.5h [ 1800 ]
Time Spent	37.5h [ 135000 ]	37h [ 133200 ]
Worklog Id		85426 [ 85426 ]

Gaurav Sodani (Inactive) made changes - 18/Oct/17 11:23 AM

Sprint

WT Sprint 38 - Enhancement [ 88 ]

WT Sprint 38 - Enhancement, WT Sprint 40 - Enhancement [ 88, 93 ]

Jaideep Vinchurkar (Inactive) made changes - 23/Oct/17 02:25 PM

Remaining Estimate	0.5h [ 1800 ]	0h [ 0 ]
Time Spent	37h [ 133200 ]	37.5h [ 135000 ]
Worklog Id		85905 [ 85905 ]

Gaurav Sodani (Inactive) made changes - 25/Oct/17 11:36 AM

Dev Due Date

05/Oct/2017

03/Nov/2017

Snehal Katkar (Inactive) made changes - 30/Oct/17 08:58 AM

Time Spent	37.5h [ 135000 ]	45.5h [ 163800 ]
Worklog Id		87482 [ 87482 ]

Jaideep Vinchurkar (Inactive) made changes - 17/Nov/17 12:15 PM

Item State

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Parent values: Development(10200)Level 1 values: On Hold(10207)

Snehal Katkar (Inactive) made changes - 21/Nov/17 01:12 PM

Link

This issue relates to ~~WT-12252~~ [ ~~WT-12252~~ ]

Jaideep Vinchurkar (Inactive) made changes - 29/Nov/17 11:11 PM

Link

This issue relates to ~~WT-12252~~ [ ~~WT-12252~~ ]

Jaideep Vinchurkar (Inactive) made changes - 04/Jan/18 09:42 AM

Assignee

Snehal Katkar [ snehal.katkar ]

Suraj Sokasane [ suraj.sokasane ]

People

Assignee:: Suraj Sokasane (Inactive)

Reporter:: Abhay Patil (Inactive)

Developer:: Snehal Katkar (Inactive)

QA:: Jayshree Nagpure (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 15/Mar/17 08:53 PM

Updated:: 04/Jan/18 09:42 AM

Dev Due Date:: 03/Nov/2017

Time Tracking

Estimated:

28h

Remaining:

Logged:

45.5h