Hi Team,
I'm utilizing a data loading function with a date column in the format dd-mm-yyyy. Although I've chosen the format as dd/mm/yyyy and set the separator to "-", it's returning zero results. Is there a method to convert the data to dd/mm/yyyy after the file is loaded? Please advise.
Thank you in advance
Hi @rvnth ,
The below configuration in data loading activity for date column should work fine:
Alternate solution:
Set the Data type as string in data loading activity
And add an enrichment activity next to data loading activity and create a column using below expression,
ToDate((Substring(Date_Field,4 ,2 )+'/'+Substring(Date_Field,1,2 )+'/'+Substring(Date_Field,7,4 )))
This will convert it to date data type. To convert it to date and time format use ToDateTime(****)
Hi @rvnth ,
The below configuration in data loading activity for date column should work fine:
Alternate solution:
Set the Data type as string in data loading activity
And add an enrichment activity next to data loading activity and create a column using below expression,
ToDate((Substring(Date_Field,4 ,2 )+'/'+Substring(Date_Field,1,2 )+'/'+Substring(Date_Field,7,4 )))
This will convert it to date data type. To convert it to date and time format use ToDateTime(****)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.