SOLVED
Convert String To Date
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
SuLewis
5 - Atom
‎07-21-2020
09:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have csv files that have the date format as a string in the format of "28 Feb, 2020". I need to convert this to a date format. I have tried date time parse and date time format in formula but keep receiving converstion error messages.
ConvError: Formula (25): DATETIMEPARSE: Cannot convert "2 Mar, 2020" to a date/time with format "%d %month, %yyyy": Expected a number for Month: 'Mar, 2020'
Any guidance greatly appreciated
Solved! Go to Solution.
Labels:
- Labels:
- Parse
2 REPLIES 2
17 - Castor
‎07-21-2020
09:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎07-21-2020
10:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you - this worked and now makes sense
