Hi team,
Their is any function to convert mentioned datetime value e.g. Sep 25 2023 3:06pm into AEP recommended datetime format like YYYY-MM-DDThh:MM:ss+00:00.
Solved! Go to Solution.
Views
Replies
Total Likes
Hi @sandip_surse - In that case just use a data prep function and map it to your target attribute in dataset.
date( D_Datetime,"MMM dd yyyy h:mma")
Where D_Datetime is the field in the source csv.
Views
Replies
Total Likes
Hi @sandip_surse -"25 2023 3:06pm" Whats the value of month in the date you mentioned?
Views
Replies
Total Likes
Sorry I miss to add
it's "Sep 25 2023 3:06pm"
Views
Replies
Total Likes
Views
Replies
Total Likes
Thanks I agree but in case we have these records in once specific attribute then how can we use above function.
like in below one CSV file
G_Id D_Datetime
5478 Sep 25 2013 3:06pm
7896 Aug 25 2022 5:05pm
how can we ingest above D_datetime value in AEP...
As per my knowledge AEP can accept only below format 'YYYY-MM-DDThh:MM:ss+00:00'
Views
Replies
Total Likes
Hi @sandip_surse - In that case just use a data prep function and map it to your target attribute in dataset.
date( D_Datetime,"MMM dd yyyy h:mma")
Where D_Datetime is the field in the source csv.
Views
Replies
Total Likes
Yes I already tried but it doesn't work might be I doing something wrong previously but after I checking again it will work..
Thank You!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies