I want date in specific format

Help Studio
, ,
1

the date format i am getting from excel is 19/feb/25 00:00:00 AM i want to convert into 19-feb-25. how can we do it

2

Hi @SSD

Try this

FormattedDate = DateTime.ParseExact(CurrentRow("Date").toString, "dd/MMM/yy hh:mm:ss tt", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MMM-yy")

Regards,

3

Hi @SSD

you can use the following

DateTime.ParseExact(DateString, "dd/MMM/yy hh:mm:ss tt", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MMM-yy")

Reference:

image
image485×179 3.51 KB

The image shows a workflow in UiPath that iterates through each row in a DataTable named "dt_dates," assigning a formatted date to the variable "dateFormatted" for each "CurrentRow." (Captioned by AI)
The image shows a workflow in UiPath that iterates through each row in a DataTable named "dt_dates," assigning a formatted date to the variable "dateFormatted" for each "CurrentRow." (Captioned by AI)502×299 5.03 KB

The image shows an Expression Editor window with an assignment statement converting a date string from "dd/MMM/yy hh:mm:ss tt" format to "dd-MMM-yy" format using the DateTime.ParseExact method in UiPath. (Captioned by AI)
The image shows an Expression Editor window with an assignment statement converting a date string from "dd/MMM/yy hh:mm:ss tt" format to "dd-MMM-yy" format using the DateTime.ParseExact method in UiPath. (Captioned by AI)976×363 9.49 KB

image
image264×113 2.59 KB

4

image
image867×447 23.9 KB

getting this error

5

Hi @SSD

You can also do string manupulation for this if the format of time changes
dateStringResult = dateVariable.ToString.Split(" “)(0).Replace(”/“,”-")

6

Hi @SSD

Is your variable already in DateTime format?

If the data type is already in DateTime, this error would occur:

image
image476×182 3.77 KB

image

The Solution, Change the code to:

Convert.ToDateTime(CurrentRow("Date")).ToString("dd-MMM-yy")

I hope this solves your issue, if so do mark it as solution
Thank You
Happy Automation :star_struck:

7

i want it in 19-feb-25 format and i have coded the same it is giving that error

8

@SSD

In Read Range Workbook activity, check Use display format

The image shows a UiPath Read Range Workbook activity with an error indicating that the workbook path has not been supplied. (Captioned by AI)
The image shows a UiPath Read Range Workbook activity with an error indicating that the workbook path has not been supplied. (Captioned by AI)1877×785 46.4 KB

If possible can you please share input excel file

Regards,

9

image
image1055×602 28.3 KB

in my excel date is 1-jan-25 the code is giving 02-19-25

10

Hi @SSD

Did you try this solution:

(I want date in specific format - #6 by V_Roboto_V)

11

image
image1154×245 11.3 KB

image
image1001×443 25.8 KB

12

Hi @SSD

Try the below syntax:

FormattedDate = DateTime.ParseExact(CurrentRow("Date").toString, "MM/dd/yyyy HH:mm:ss tt", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MMM-yy")

Hope it helps!!

13

Hi @SSD

The error is caused because the date time is wrongly formatted.

as per your excel, the value is 01/01/2025 18:19:55 AM which is invalid, because 18:19:55 is a 24 hour format, which you cannot mention as AM

14

Hi @SSD

Here is updated solution, do let me know if it works or not:

Step 1: The issue was as mentioned earlier, 24 Hour format cannot have an AM or PM. So let us first remove it from the date String:

dateValid = CurrentRow("Date").ToString.Replace(" AM", "").Replace(" PM", "")

Step 2: Update the existing assign statement with the new format of “dd/MM/yyyy HH:mm:ss”. (Previously it was “dd/MM/yyyy hh:mm:ss tt”)

dateFormatted = DateTime.ParseExact(dateValid, "dd/MM/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MMM-yy")

The final flow:

The image shows a workflow of activities in UiPath Studio, including assigning and formatting date variables and logging a formatted date message. (Captioned by AI)
The image shows a workflow of activities in UiPath Studio, including assigning and formatting date variables and logging a formatted date message. (Captioned by AI)513×476 12.3 KB

The Output:

image
image262×124 2.48 KB

15

Hey @SSD if your date input in string format and you want to modify that date in your require format type use that logic.

The image shows a UiPath workflow where a date string "19/Feb/25 00:00:00" is being converted to the format "dd-MMM-yy" using a DateTime.ParseExact method in an Expression Editor. (Captioned by AI)
The image shows a UiPath workflow where a date string "19/Feb/25 00:00:00" is being converted to the format "dd-MMM-yy" using a DateTime.ParseExact method in an Expression Editor. (Captioned by AI)954×528 28.7 KB

cheers

16

@SSD

First thing when you read from excel the format needs to be checked in locals pnel rather than on excel…based on the format it reads the date in UiPath is what you need to write the conversion expression

Cheers