Need to convert String value to Date Time

[SaravanakumarB1]

In one of my requirement, there is a last pay date field which is in String with value "YYYYMMDD". I need to convert this value to Date time option AEP. Please give some suggestion to convert.

Thanks,

Saravanakumar

[bjoern__koth · Accepted solution]

Hi @SaravanakumarB1 

do you mean the value comes in as XDM field of type string and you need to transform it into a DateTime?

For this, you could just use the date data prep functions within a calculated field.

https://experienceleague.adobe.com/en/docs/experience-platform/data-prep/functions#

Let's say you have the following schema

and a matching CSV

When you run a simple CSV import that creates a dummy dataset based on your schema

and map the fields accordingly.

1. message should automatically be correct

2. the myDate mapping must be removed and a new calculated field (New field type > add calculated field) added instead

important: make sure to pass in your incoming date-string format, with "y" for year, "M" for month and "d" for day.

date(myDate, "yyyyMMdd")

After importing the csv, your dataset should look something like this

[SaravanakumarB1]

We are fetching data from S3, in the file the pay_date value they have given as "20351209". I need to convert this value to UTC timestamp. Please advice

[bjoern__koth]

The mapping should still be done in your S3 import workflow. And the result will be transformed into an UTC timestamp with midnight as hour:minutes part.

 >