Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

How to format data in Data prep without the time component

Avatar

Community Advisor

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

 

 

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

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

 

 

Avatar

Community Advisor

Hello @Manoj_Kumar_ ,

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

Thnaks