Hi I need help to convert after row 5 and everything after to date format for chosen multiple fields
ie
F40 | F41 |
40 | 41 |
null | null |
null | null |
Revised Date | Start Date |
3-Nov-23 | 30-Oct-23 |
17-Apr-23 | ######## |
17-Apr-23 | ######## |
17-Apr-23 | ######## |
17-Apr-23 | ######## |
17-Apr-23 | ######## |
to the dates being yyyy-mm-dd format.. and leave the headers the same.. not sure if that is possible.
@wonka1234 Alteryx doesn't support multiple data types in a single column, I mean the same column cannot have DATE data type and STRING date type like excel. If you want to keep only the String type here is the one way of doing this