Data type issue - VERY URGENT

[satya04]

I am trying to input 36 files with same schema into Alteryx and perform a summary of transactions to see total value on a monthly basis.

The first row is not the header and I have to adjust it in this way

1. Select tool to rename header

2. Sample tool to exclude first 2 rows so that the data is being pulled from the first row

3. Filter tool to exclude the column headers for the other 35 files which are also obtained through the input tool.

After doing this changes, I have encountered the following issues

1.  Date values appear as null (conversion error for not being a valid date)

2.  Conversion error for ConvError: Select (12): Total Transaction Value ($USDmm, Historical rate): - is not a valid number.

The data type is not working correctly for both the fields "All Transactions Announced Date" and "Total Transaction Value ($USDmn, Historical rate)". Please guide me on how this can be addressed.

[satya04]

@binu_acs I thing I can address this now. Thank you for your guidance. 

Can you please guide me in updating the date format from 12/31/2000 to Dec 2020?

[binu_acs]

@satya04  use the DateTimeFormat() and DateTimeParse() function for your requirement