How to change the date formats

[anjani_priya]

How to change the date format like 31.05.2023 to May’2023?
How to change the format of dates like our requirement?

[vinitha_yachamaneni]

Hi @anjani_priya

You can try this

Assign activity:
originalDate = DateTime.ParseExact(yourDateString, “dd.MM.yyyy”, CultureInfo.InvariantCulture)

Assign activity:
formattedDate = originalDate.ToString(“MMM’yyyy”)

Write Line activity:
"Formatted Date: " + formattedDate

[Palaniyappan (Forum Leader)]

Try with expression in assign activity

stroutput = DateTime.ParseExact(strinput.ToString.SubString(0,10), “dd.MM.yyyy”, CultureInfo.InvariantCulture).ToString(“MMM’yyyy”)

Have a view in this for all Datetime operations

All about Datetime - UiPath

Hi All, My recent post on datatable [All About Datatable- UiPath] (All about Datatable - UiPath) was received well in forum with great feedbacks and many suggested to provide some tutorial on topics which are discussed often in our forum In regards to that I would like to share the commonly used expression for DATETIME conversion Let’s get started one by one 1. Get Current Date in string format Datetime.Now.ToString() (Output - string type - “dd/MM/yyyy hh:mm:ss”) **To get only current da…

Cheers @anjani_priya

[anjani_priya]

@Palaniyappan

stroutput = DateTime.ParseExact(strinput.ToString.SubString(0,10), “dd.MM.yyyy”, CultureInfo.InvariantCulture).ToString(“MMM’yyyy”)

where should i give the input

[anjani_priya]

Where should i pass my value?

[Palaniyappan (Forum Leader)]

In assign activity @anjani_priya
Strinput is the variable with which u can pass the input value

[vinitha_yachamaneni]

@anjani_priya

you need to give your date in “yourDateString” Variable from above example

[anjani_priya]

[Parvathy (PS Parvathy)]

Hi @anjani_priya
Remove the double quotes and give it again. It will solve the error.

Regards

[Palaniyappan (Forum Leader)]

Try to type in again
It would work @anjani_priya

[anjani_priya]

[Praveen_Mudhiraj]

Hi you can try this way

DateTime.ParseExact("31.05.2023","dd.MM.yyyy",System.Globalization.CultureInfo.CurrentUICulture).ToString("MMM yyyy")

@anjani_priya

[Praveen_Mudhiraj]

follow this steps

@anjani_priya

[anjani_priya]

if the date is like 31 december 2021 or any other format how to change that to mm’yyyy format?

[Palaniyappan (Forum Leader)]

Pass them in double quotes @anjani_priya

“31.05.2023”

[Palaniyappan (Forum Leader)]

If that’s the case the format changes accordingly like this

dd MMMM yyyy - we need pass accordingly

stroutput = DateTime.ParseExact(strinput.ToString, “dd MMMM yyyy”, CultureInfo.InvariantCulture).ToString(“MMM’yyyy”)

I would recommend to have a view on this to know all the date format

All about Datetime - UiPath

Hi All, My recent post on datatable [All About Datatable- UiPath] (All about Datatable - UiPath) was received well in forum with great feedbacks and many suggested to provide some tutorial on topics which are discussed often in our forum In regards to that I would like to share the commonly used expression for DATETIME conversion Let’s get started one by one 1. Get Current Date in string format Datetime.Now.ToString() (Output - string type - “dd/MM/yyyy hh:mm:ss”) **To get only current da…

@anjani_priya

[anjani_priya]

If the formats are changing dynamically how to declare?

[Palaniyappan (Forum Leader)]

Date format has to be standard and defined
we need to make it robust with stable dateformat
which is actually a good practice. Ask the user or system that generates the report to create the file with same dateformat

Or atleast if u know the possible different date format
Then you can pass it as array
It’s in above thread which I shared

Convert a String of multiple possible date formats to a Datetime variable

Say you have a date string which can be of different formats for each time it is being used like
“dd/MM/yyyy”, “MM/dd/yyyy”, “dd/yy”

Then have all these possible formats in a array variable named arr_formats

Like this

arr_formats = {“dd/MM/yyyy”, “MM/dd/yyyy”, “dd/yy”}

Then to convert that string as Datetime

var_datetime = DateTime.ParseExact(Strinput.ToString, arr_formats, System.Globalization.CultureInfo.InvariantCulture, DateTimeStyles.None)

@anjani_priya

[Praveen_Mudhiraj]

Try this way

str= "31 december 2021"

CDate(str).AddMonths(0).AddDays(-1).toString("MMM yyyy")

@anjani_priya

[Palaniyappan (Forum Leader)]

@Palaniyappan

Convert a String of multiple possible date formats to a Datetime variable

Hope this Clarifies
@anjani_priya