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

TOPIC: String to Date

String to Date 2 years 1 month ago #17028

Hi, is there a function to convert a string to date?

i'd have a string containing "7/6/2017"

i need it to be a date like " 07/06/2017"

thanks!

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

String to Date 2 years 1 month ago #17029

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7618
  • Karma: 33
  • Thank you received: 419
Of course there is.
It is called reformat date
www.etl-tools.com/wiki/aetle/transformation_functions/date

Are you planning to load this data into the database?
Mike

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

String to Date 2 years 1 month ago #17032

I assumed that might be the correct function - except it is not working. I have even selected all date formats and it still doesn't work. I am writing to a csv.

Source XLXS File - destination CSV.
Attachments:

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

String to Date 2 years 1 month ago #17033

  • Carl A
  • Carl A's Avatar
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 65
  • Karma: 3
  • Thank you received: 2
Add "M/D/YYYY" as a custom format
Attachments:

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

String to Date 2 years 1 month ago #17034

that worked - thank you!

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

  • Page:
  • 1

We have 273 guests and no members online