Want to convert date into MM.dd.yyyy format

Hi All,
Please help me out with below scenario,

I am fetching date from excel using read cell (in excel variable having date time data type and foramt is same as MM.dd.yyyy) while using it on SAP its going as dd/MM/YYYY , so SAP not able to get that date format, so correct format is MM.dd.yyyy. so do i need to convert this or any other solution for same.

Thanks in advance.

Hi @amruta_pawar

Try this one

CDate(row(“Your Date”).Tostring).Tostring(“MM.dd.yyyy”)

Kommi Jeevan

thanks a ton , it worked… :slight_smile:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.