I have a column it contains 18-Sept-22 (Date format in Excel) and i have to convert that date to 2022.09.18. In my workflow am reading that excel and passing it in a for each row data table, am getting value as 4490. So any one please help in this regards…

How to convert dd-MMM-yy to yyyy.MM.dd format?

vanithavs (Vanithavs) September 19, 2022, 11:43am 6

The date column is in date format in Excel, so that am getting value 4490 in for each row. that’s why am not able to convert to correct date format.

Topic		Replies	Views
How to convert date in column to date format(dd/MM/yyyy) Studio studio , question , workflow_diff	18	1711	October 5, 2023
How to convert string to dd-mmm-yyyy Help	11	6934	July 22, 2019
Convert date format to another Studio	4	1203	December 31, 2022
How to convert date format in excel from format 3-Nov-17 to 20171103 Help	2	1051	November 1, 2018
Date formatting problem Help studio	3	818	January 16, 2021