9/14/2022(MM/dd/yyyy) Change this date to 14/9/2022(dd/MM/yyyy)

Can you please resolve this

Hi @428e10c08f35f5a9e7b4cece6

Try with the below expression

Cdate("9/14/2022").Tostring("dd/MM/yyyy")

or

Cdate("9/14/2022").Tostring("dd/M/yyyy")

Regards
Gokul

HI @428e10c08f35f5a9e7b4cece6

Try this expression

DateTime.ParseExact("9/14/2022",{"M/dd/yyyy","MM/dd/yyyy"},System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None).ToString("dd/M/yyyy")

DateTime.ParseExact("9/14/2022",{"M/dd/yyyy","MM/dd/yyyy"},System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None).ToString("dd/MM/yyyy")

Regards
Sudharsan

Output

image

Regards
Gokul

Hi Gokul,

date place I’m created one variable but throwing error

Try on this

Share the Input format @428e10c08f35f5a9e7b4cece6

Hi,

Please take this excel screenshot

Can you share the excel file @428e10c08f35f5a9e7b4cece6

HI @428e10c08f35f5a9e7b4cece6

Which column are you changing the format

Try to use If condition for the empty rows in the Date column

image

Regards
Gokul

Hi,
Please find the attached excel file
exceldata.xlsx (9.5 KB)

Check out the XAML file

DateChangeFormat.xaml (8.6 KB)

Note : In this workflow i have done it for AsOnDate column. If you need more columns do the same FromDate & ToDate

Regards
Gokul

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