I Want to Covert the String Variable Contain "09222023" to this Format 22.09.2023

[Gopikrishna_S]

Suggest suitable expression to get the required output, its a string Variable type, Thanks i n advance for your help

[Parvathy (PS Parvathy)]

Hi @Gopikrishna_S

Input= "09222023"
Output= DateTime.ParseExact(Input,"MMddyyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd.MM.yyyy")

Hope it helps!!

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @Gopikrishna_S ,
Can you share some template input?

DateTime.ParseExact(strString,“MMddyyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd.MM.yyyy”)
regards,

[Palaniyappan (Palaniyappan P)]

Hi

Try with this expression

Stroutput = DateTime.ParseExact(Strinput.ToString.Trim,“ddMMyyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd.MM.yyyy”)

Have a view on this for all Datetime conversion

All about Datetime - UiPath

Hi All, My recent post on datatable [All About Datatable- UiPath] (https://forum.uipath.com/t/all-about-datatable-uipath/386445) 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…

Hope this helps

cheers
@Gopikrishna_S

[sasi_poosarla (sasi p)]

@Gopikrishna_S

DateTime.ParseExact(str,“MMddyyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd.MM.yyyy”)

[sai_gupta]

you can try this:

Assign: inputDateString=“09222023”
outputDate = DateTime.ParseExact(inputDateString, “MMddyyyy”, System.Globalization.CultureInfo.InvariantCulture)

@Gopikrishna_S

[Gopikrishna_S]

@Nguyen_Van_Luong1

DateTime.ParseExact(strString,“MMddyyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd.MM.yyyy”)

Assign: Expression Activity type ‘VisualBasicValue`1’ requires compilation in order to run. Please ensure that the workflow has been compiled.

[Yoichi]

Hi,

it’s double quote matter of Windows project. Can you try to use (copy and paste) the following expression?

DateTime.ParseExact(strString,"MMddyyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd.MM.yyyy")

FYI

Troubleshooting Guide : Conversion from Windows-Legacy project to Windows project

This topic describes troubleshooting guide regarding conversion from Windows-Legacy project to Windows project as of Dec 2023. Hope this helps those who face these problems. 1 Quick Reference by Error Messages, Situation etc. Phase Error message / Situation Reference Open project foobar.xaml: Cannot create unknown type’{clr-Namespace:UiPath.foo.Activities;assembly=UiPath.bar.Activities}ActivityName’. 2.2 Missing Activities package OR 2.3 Missing activity Development Unable to set pro…

Regards,

[Gopikrishna_S]

@Palaniyappan

DateTime.ParseExact(Strinput.ToString.Trim,“ddMMyyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd.MM.yyyy”)

Assign: Expression Activity type ‘VisualBasicValue`1’ requires compilation in order to run. Please ensure that the workflow has been compiled. Getting this error

[Praveen_Mudhiraj]

Try this

your issue is double quotes , you can copy and paste in assign activity below one

DateTime.ParseExact(strString,"MMddyyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd.MM.yyyy")

@Gopikrishna_S

[Gopikrishna_S]

Getting the Required Output Thank You

[Gopikrishna_S]

Getting the Required Output Thank You palaniyappan