Issues in implementing date() function | Community
Skip to main content
_
_abs9900
Level 2
January 16, 2024
Solved

Issues in implementing date() function

  • January 16, 2024
  • 1 reply
  • 1019 views

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

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Sneha-Parmar

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. 

1 reply

Sneha-Parmar
Community Advisor
Sneha-ParmarCommunity AdvisorAccepted solution
Community Advisor
January 16, 2024

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. 

    _
    _abs9900Author
    Level 2
    January 16, 2024

    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?

     

      Terms & ConditionsAccessibility statement

      Loading footer...