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
Solved! Go to Solution.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Hello @_Manoj_Kumar_ ,
I used format(date("date as string"),''DD-MM-YYYY') because the date was passed as string
Thnaks
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies