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

Help Activities
, ,
1

Can you please resolve this

2

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

3

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")

image
image1315×330 21.6 KB 

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

image
image1332×343 32.1 KB

Regards
Sudharsan

4

Output

image

Regards
Gokul

5

Hi Gokul,

date place I’m created one variable but throwing error

IMG_20220924_173538
IMG_20220924_1735381920×1442 260 KB

6

Try on this

7

Share the Input format @428e10c08f35f5a9e7b4cece6

8

Hi,

Please take this excel screenshot

IMG_20220924_175450
IMG_20220924_1754501920×1442 429 KB

9

Can you share the excel file @428e10c08f35f5a9e7b4cece6

10

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

11

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

12

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

13

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