Solved
Data prep function
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.
arpan-gargAccepted solution
Community Advisor
October 3, 2023
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'
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.