I need to convert a date to a string and then back to a date as I am experiencing the problem outlined in this article. How do you go about converting a Date to String?
https://stackoverflow.com/questions/50476941/error-while-writing-data-from-python-to-redshift-invalid-date-format-length
Hi !
Did you take a look at the DateTime Tool in the Parse section ?
Hi
To change a date to a string, use the DateTimeFormat(dt,f) function in a formula tool (Find examples of the function under the DateTime section on this page). The syntax for the format string, the f parameter, is unique to Alteryx so check out DateTimeFunctions.htm for samples
Dan
Hi Dan,
I am trying to convert a Date Field (coming from Salesforce) into a String or Number as when I attempt to move the date field to Amazon RedShift it gives me an error because there are blank values (not all rows have certain dates completed). With that said, I have read that I can turn the date field into a string or number and then work with it outside of Alteryx (within Tableau) that way.
Everything I see is about turning a string into a date, not the other way.
Thanks in advance for any further assistance you can provide.
David
