How to change the date separator from mm/dd/yyyy to mm.dd.yyyy and add 00:00 in the end?

[Greggy (Greggy O)]

This is my input 01/08/2015 and i want it to look like this 01.08.2015 00:00

Can someone help me I currently have a code I have assigned it to hostDateFrom = DateTime.ParseExact(hostDateFrom.toString(), “MM/dd/yyyy”, Globalization.CultureInfo.InvariantCulture).ToString(“MM.dd.yyyy”)

but im getting an error

[Yoichi]

HI,

Can you try String.Replace mathod as the following?

yourString.Replace("/",".")+" 00:00"

Regards,

[Sudharsan_Ka]

HI @Greggy

Checkout this expression

DateTime.ParseExact(hostDateFrom.toString, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MM.dd.yyyy hh:mm”)

Regards
Sudharsan

[Tapan_Behera1 (Tapan Behera)]

Hi @Greggy try this:

DateTime.ParseExact(yourdatevariable, “MM/dd/yyyy”, Globalization.CultureInfo.InvariantCulture).ToString(“MM.dd.yyyy hh:mm”)

[Gokul001 (Gokul Balaji)]

Hi @Greggy

Try like this expression

DateTime.ParseExact(hostDateFrom.toString, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MM.dd.yyyy HH:mm”)

Or

CDate(hostDateFrom.toString).Tostring("MM.dd.yyyy HH:mm")

Output

Check out this blog and tutorial for more reference

DateTime Operations in UiPath - ExcelCult

Recollect the basics of Date Format, String Manipulation and LINQ

Hello Everyone, I would like to present this post who are looking for the expressions related to the Date Format, String manipulation and LINQ Basic of Date formatting In this below topic, you will learn about Date Formats Convert datetime to week of year System.Globalization.CultureInfo.CurrentCulture.Calendar.GetWeekOfYear(System.DateTime.Now, System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.CalendarWeekRule,System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.Fi…

Date Expression

Hello Everyone, Hope you are doing good I would like to present this post who are looking for the expressions related to the Date Expression Get the Week Count W"+System.Globalization.CultureInfo.InvariantCulture.Calendar.GetWeekOfYear(Today,System.Globalization.CalendarWeekRule.FirstDay,DayOfWeek.Monday).ToString [image] Get the 5 Business days count Enumerable.Range(0, new DateTime(2023,12,31).DayOfYear + 1).Select(Function (x) New DateTime(2023,1,1).AddDays(x)).Where(Function (x) Not (x…

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…

Regards
Gokul

[Gokul_Jayakumar (Gokul Jai)]

@Greggy

DateTime.ParseExact(hostDateFrom.toString(), “MM/dd/yyyy”, Globalization.CultureInfo.InvariantCulture).ToString(“MM.dd.yyyy”)

Hello @Greggy
try this

DateTime.ParseExact(hostDateFrom.toString.Trim, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MM.dd.yyyy HH:mm”)

[Gokul_Jayakumar (Gokul Jai)]

@Greggy

but im getting an error

@Greggy , Kindly share the what type of error you are facing.

[Sudharsan_Ka]

@Sudharsan_Ka

HI @Greggy

Checkout this expression

DateTime.ParseExact(hostDateFrom.toString, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MM.dd.yyyy hh:mm”)

@Greggy
If you have error like value is not a valid date format something like this

• Keep a message box and print the hostDateFrom and check the format there if the format in the expression and the message box differ add the additional format in the expression like

DateTime.ParseExact(hostDateFrom.toString,{"MM/dd/yyyy","MM/dd/yyyy hh:mm:ss","dd.MM.yyyy"}, System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString(“MM.dd.yyyy hh:mm”)

You can simply add the any number of date formats inside the {“”,“”} and the formats should be seperated by comma

The above expression will look into array of string and choose the apt format as per the input string and convert them and return you the output of desired format

Regards
Sudharsan

[Anil_G (Anil Gorthi)]

@Greggy

hostDateFrom

Hi @Greggy

You can use DateTime.ParseExact(hostDateFrom.toString(), “MM/dd/yyyy”, Globalization.CultureInfo.InvariantCulture).ToString(“MM.dd.yyyy 00:00”) adding 00:00 will add a static time as you need and also I see you have the value back to hostDateFrom. If hostDateFrom is in Date format than it will fail as the output of right argument is string and you are trying to assign to Date

If you need date than add like this DateTime.ParseExact(DateTime.ParseExact(hostDateFrom.toString(), “MM/dd/yyyy”, Globalization.CultureInfo.InvariantCulture).ToString(“MM.dd.yyyy 00:00”)“MM.dd.yyyy hh:mm”, Globalization.CultureInfo.InvariantCulture)

cheers

[Achiranga (Achiranga Gunasekara)]

DateTime.ParseExact(hostDateFrom.toString, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MM.dd.yyyy hh:mm”)

or modify Date activity