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?

Gokul_Jayakumar (Gokul Jai) September 19, 2022, 11:49am 7

While using the read range of the worksheet, kindly check the Properties of PreserveFormat and try again.

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