Issue with ASC file as Datasource

[pramodb]

Hi

In Cognos Transformer 10.2.1, date field is not coming as 'YYYY-MM-DD' format but 'MM-DD-YYYY' format(In Time tab, Date input format selected as 'MDY').

1. How to modify this column to YMD format which is correctly reflecting in Cognos 7, used add_days function, any other option?

2. First 2 rows are header, how to ignore both?

Source is .ASC file and Source Type is kept as "Delimited-field text with column titles -  Field Delimited as "~"with first 2 lines as column names.

thanks