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