Forum Discussion
Help with Text to Date Formula
Hello, I have been using many different methods for attempting to convert text and date - but failing miserably! Essentially, the way I can download data provides dates that appear like this: ...
i think that the main issue is the suffix after the day, and lack of a comma between day and year
I would find/replace or automate that the following
find: ‘rd’
replace ‘,’
find: ‘st’
replace ‘,’
find: ‘nd’
replace ‘,’
on my end it changed to a date as soon as I did that