How to format data in Data prep without the time component

[Luca_Lattarini]

Hello guys,

I need to store a date without the time component and I am thinking to use the Data prep to do this. Any suggestion on how to remove time component from the date?

Thanks

[Manoj_Kumar_ · Accepted solution]

Hello @Luca_Lattarini 

How to format the data will depend on the original format of the data.

for eg If your original date format looks like this "2022-09-13 10:00:00".

Then you can do something like this:

split(myData," ")[0]

The output will be 2022-09-13

Refer to this page for all functions:

Data Prep Mapping Functions | Adobe Experience Platform

You can also use the date_part function

eg: date_part(date("2022-09-13 12:55:12"), "MM")

The output will be 09

[Luca_Lattarini]

Hello @Manoj_Kumar_ ,

I used format(date("date as string"),''DD-MM-YYYY') because the date was passed as string

Thnaks