How to convert date format(mm/dd/yyyy) to (dd/mm/yyyy) and also how to change string into date format

excel

#1

while fetching data from excel sheet i m getting the date format (dd/mm/yyyy) but requirement is to change it to (mm/dd/yyyy) format. please help me with this.


#2

DateTime.ParseExact(yourdatevariable.toString(), “dd/MM/yyyy”, Globalization.CultureInfo.InvariantCulture)
.ToString(“MM/dd/yyyy”)
Use this in an assign activity!


#3

DateTime.ParseExact(here_your_date.ToString(),“dd/MM/yyyy”,Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”)
and please add system.globalistaion in imports.


#4

Dates.xaml (5.7 KB)

Here is the workflow! :slight_smile:


#5

THANK YOU FOR YOUR HELP


#6

Please mark it as solution :slight_smile: