data loading activity

[rvnth]

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

[ParthaSarathy · Accepted solution]

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(****)