Convert after row 5 and everything after to date format for chosen multiple fields

wonka1234

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.

convert row 7 and on to date time for chosen multiple fields.yxmd

binu_acs

@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

convert row 7 and on to date time for chosen multiple fields.yxmd