top of page

Data Prep Date Formatting:

Use case: The Input contains dates formatted as year, month and day. In this case the first character determines if the year should begin with 19 or 20.   If the first character is 0 then the year starts with 19, and when the first character is 1 the year starts with 20.  

 

The remainder of the date following the 0 or 1 is the remaining year digits followed by month followed by day.

 

Objective: Please convert these strings into date formatted field.

Data Set #1                                                                                                      

Final Data Set Solution

Workflow with Detail

 

© 2023 by GREG SAINT. Proudly created with Wix.com

  • Facebook - Grey Circle
  • Twitter - Grey Circle
  • Google+ - Grey Circle
  • LinkedIn - Grey Circle
bottom of page