Issues in implementing date() function

[_abs9900]

Hi Team,

I've a requirement to transform data incoming date field to specific format - yyyy-MM-dd

From input source system DOB field is coming in 2002-07-07T00:00:00 format
While applying transformation as date(dob,"yyyy-MM-ddTHH:mm:ss"), I'm seeing preview result as "2002-07-07T00:00:00.000Z"
But when the data flow runs, it is ingesting empty values in dataset.

Question 1: What could be the reason why no data is getting ingested in dataset, while I can preview the data in data mapping phase?
Question 2: I've to ingest data in yyyy-MM-dd format in an AEP date field. How can I achieve this with data prep functions?

Snapshot 1: Data mapping preview

Snapshot 2: Empty data in dataset

[Sneha-Parmar · Accepted solution]

Hi @_abs9900 ,

I too faced this issue with date format function. At the end I have to change my input data format since date format function did not work as expected. 

[_abs9900]

Hi @Sneha-Parmar ,

Thanks for your response.

Could you please let me know, to which format you converted the source data

Can you provide an example of data transformation done?

[NimashaJain]

@Sneha-Parmar Can you please update here with format?