Hallo @João Marques , 

Can you share more information or provide a simple example?

As I understand, you have an issue with date formatting. Have you tried converting it to text and saving it in the appropriate format?

Hi @João Marques!

The documentation is not cleared about date formats when convert excel file data to record list.

I would say that action use the same structure that it is used on TextToDateTime() function:

"... You should check the limits of the Date Time data type. You should also ensure that the Date Time you type in the argument complies with the default Date Time format (yyyy-mm-dd hh:mm:ss, yyyy/mm/dd hh:mm:ss, and yyyy.mm.dd hh:mm:ss) or the server’s environment configuration."

A "quick fix" if you are getting troubles: on Outsystems structure set the attribute to Text, read as Text, and when you need that information, treat in your format.

Hi Kerollos and Eduardo, 

Thank you both for your replies.

I can work around the issue and I can also correct it permanently. I simply just want to understand what's under the hood. 

Some relevant data: 

• We manage our own infrastructure.
• In the environment configuration (in Service Center), I see that we have the date format has dd-mm-yyyy. 
• A few weeks back the excel imports, using that ExcelToRecordList, when having a column Date (not Date Time), started to give errors stating that we are trying to pass string in a date field. 
• That lead me to the conclusion that when using ExcelToRecordList we are validating the date format from another server environment config. 
• When checking the Get-Culture powershell command in one of the servers I see that we have a system one and a current user one and those being different might be a change that made this issue. I didn't confirm yet that there was a change in those configurations on the last weeks.

This was what made me do this question and try to understand how are we validating a format type in ExcelToRecordList. 

Thank you in advance.