Can you please resolve this
Try with the below expression
Cdate("9/14/2022").Tostring("dd/MM/yyyy")
or
Cdate("9/14/2022").Tostring("dd/M/yyyy")
Regards
Gokul
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
Regards
Gokul
Try on this
Which column are you changing the format
Try to use If condition for the empty rows in the Date column
Regards
Gokul
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.