Not reading the date field during the Excel import

Solved

Question

Hi Team,

Im using excel to recordlist, But its not reading value from the date column from excel.

please find the excel and structure which im using in excelToRecordList. Please add your suggestions

Thanks

on 14th Mar

mvp_badge

MVP

Solution

Hi pasupathi,

It seems your excel header for the Ship out Date has an ENTER while your OutSystems structure attribute label does not have (nor it supports it).

Can you try without the ENTER in the Excel file?

If you really need ENTERs, you're entering a more advanced scenario which requires a more advanced solution like Advanced Excel forge component.

Kind Regards,
João

on 14th Mar

Thanks Marques . it works good.

on 14th Mar

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.