Litigation Support

Litigation Support - Tool Tips - Converting Date Field Format Using Excel

By Ann Halkett posted 06-15-2021 10:52

  

In litigation support, we often receive data in formats that may not work for our software platforms. A key example is the date field. Dates can be formatted in many different ways, but the software platform may only recognize one format for sorting purposes.  Therefore, extracting the date field information in the format that you require it in can be a bit of a pain.

However, you can use Excel to assist with that process.  The following is a formula that you can use to assist with the conversion process:

Convert Date infor - DD/MM/YYYY to MM/DD/YYYY

Formula:

=MID(TRIM(B2),4,2)&"/"&MID(TRIM(B2),1,2)&"/"&MID(TRIM(B2),7,4)



#Firm
#LitigationSupportoreDiscovery
#PracticeManagementandPracticeSupport
1 comment
35 views

Permalink

Comments

06-15-2021 10:56

Here are past tips in the series:

Kathy Dallaire
Submitted and posted blog post on  January 11th. 
https://www.iltanet.org/blogs/kathy-dallaire-ceds1/2021/01/11/litigation-support-tool-tips-beyond-find-and-repla 

Shannon Bales
Submitted and posted on January 24th. 
https://www.iltanet.org/blogs/shannon-bales1/2021/01/24/achieving-greasy-fast-demon-speed-in-exhibit-workf

Sean K. O'Shea
Submitted and posted on January 30th 
https://www.iltanet.org/blogs/sean-oshea1/2021/02/01/running-regex-searches-with-a-grep-utility

Amy Bowser-Rollins
Submitted and posted on February 9th 
https://www.iltanet.org/blogs/amy-bowser-rollins1/2021/02/09/litigation-support-tool-tip-create-folders-from-a

Stephanie Clerkin 
Submitted and posted on March 2nd 
https://www.iltanet.org/blogs/stephanie-clerkin/2021/03/02/litigation-support-tool-tips-adobe

Catherine “Cat” Casey
Submitted and posted on March 16th
https://www.iltanet.org/blogs/catherine-casey1/2021/03/16/lets-get-digital-uncovering-evidence-in-the-digita

Catherine "Cat" Casey -
Submitted and posted on March 29th. https://www.iltanet.org/blogs/catherine-casey1/2021/03/29/new-kids-on-the-ediscovery-block

Catherine "Cat" Casey
Submitted and posted on April 15th.
https://www.iltanet.org/blogs/catherine-casey1/2021/04/15/demystifying-the-alphabet-soup-of-legal-ai

Ann Halkett
Submitted and posted on May 3rd.
https://www.iltanet.org/blogs/ann-halkett1/2021/05/03/litigation-support-tool-tips-calculate-time-zone-o

Catherine 'Cat' Casey
Submitted and posted on May 3rd.
https://www.iltanet.org/blogs/catherine-casey1/2021/05/03/navigating-the-new-legaltech-landscape

Tiana Van Dyk  
Submitted and posted on May 17th.
https://www.iltanet.org/blogs/tiana-van-dyk1/2021/05/17/litigation-support-tool-tips

Carolyn Anger 
Submitted and posted on June 1st
https://iltanet.org/blogs/carolyn-anger1/2021/06/01/a-day-in-the-life-of-onenote

Peter Sanford
Submitted and posted on June 14th.
https://iltanet.org/blogs/peter-sanford/2021/06/14/heres-what-else-you-can-do-with-machine-learning