Comments
-
There was, so that worked perfectly! Thank you so much!
-
Update - I was able to figure it out using this formula: DATE_FORMAT(STR_TO_DATE(SUBSTRING_INDEX(Date, '/', -1), '%e-%b-%y'), '%b %e, %Y')
-
@MichelleH There is one more similar situation I'm having issues with that you might be able to help me on. I'm trying to change this "Date" field into a Date instead of Text. It's also having issues parsing. What's the best formula to fix that? I have attached a picture of how the Date string is.
-
That's what it was. Thank you for thinking of that! Only difference from your formula is I had to use REGEXP_REPLACE function instead of REGEX_REPLACE. Here was my final output: CAST(REGEXP_REPLACE(Ad fees,'[^0-9.]','') as DECIMAL()) Thanks again!
-
Thank you both! That was very helpful.