Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Reformat Date = Null on single digit months from Excel / CSV Files

Reformat Date = Null on single digit months from Excel / CSV Files 1 year 3 weeks ago #18798

  • cchavez
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 26
  • Thank you received: 0
I have to convert different types of dates from an enrollment process from Excel and CSV files to a specific specification of YYYYMMDD for an external partner.

Using the format or reformat date properties works but does not handle single digit months (e.g.., 3/29/1981 results in null but 10/20/1975 converts correctly).

My question is there a way to normalize the dates in a way in either the Validator or the Transformer that whether or not they use 09 or 9 we can convert the month or day to two digits.

I have attached some screenshots of an example and this is dummy data nothing confidential.
Attachments:

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

Reformat Date = Null on single digit months from Excel / CSV Files 1 year 3 weeks ago #18799

  • Carl A
  • Carl A's Avatar
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 67
  • Karma: 3
  • Thank you received: 2
Try M/D/YYYY in your reformat action
The following user(s) said Thank You: admin

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

Reformat Date = Null on single digit months from Excel / CSV Files 1 year 3 weeks ago #18800

  • cchavez
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 26
  • Thank you received: 0
ok I will try the M I wasn't sure if it would null on month 10, 11, and 12.

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

Reformat Date = Null on single digit months from Excel / CSV Files 1 year 3 weeks ago #18801

  • cchavez
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 26
  • Thank you received: 0
m/d/yyyy handles the different data types thank you.

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

  • Page:
  • 1

We have 191 guests and 2 members online