Dear all, I have value cell below: [image] when get and show it. The value is “11/23/2017 0:00”. Now, i want to convert it to format “MMdd”. I tried use CDate(DateTime_v).ToString(“MMdd”) or DateTime.ParseExact(BuyDate_v.ToString, “MMdd”, enUS, DateTimeStyles.None). But it is not correct. Ple…

@AKY try this Convert.ToDateTime(ur variable name).ToString(“MMdd”)

Hi @Manjuts90 , I tried by this way and i have the result below. 1/27/1903 0:00 Not the right time i need. Do you have another help? Thank you

Hi @AKY , Try below code. DateTime.ParseExact(BuyDate_v.ToString, "MM/dd/yyyy h:ss", System.Globalization.CultureInfo.InvariantCulture).ToString("MMdd") Regards, Arivu

Hi @arivu96 , I tried with your help. And have error below: [image] So i think value BuyDate_v.ToString when i got was not correct. I message box again and the value right of BuyDate_v.ToString is “11/23/2017 00:00:00” . So, how can i change “MM/dd/yyyy h:ss” to correct?

Hi @AKY , [image] AKY: “11/23/2017 0:00” you told above format. [image] AKY: BuyDate_v.ToString is “11/23/2017 00:00:00” . Try below Code. DateTime.ParseExact(BuyDate_v.ToString, "MM/dd/yyyy hh:mm:ss", System.Globalization.CultureInfo.InvariantCulture).ToString("MMdd") Regards, Ari…

[image] arivu96: MM/dd/yyyy hh:mm:ss Hi @arivu96 , After convert, this is the result: 1/27/1903 12:00:00 AM. I don’t know how it content “AM”. Please help to check. Thank you

Convert date time format

Learning Hub Academy Feedback

RAKESH_KUMAR_BEHERA (RAKESH KUMAR BEHERA) August 23, 2020, 2:56pm 8

This video may help: UiPath VB.Net Complete Tutorial (System DateTime)

Topic		Replies	Views
Date time conversion to string and get only date in string format Studio studio , question , activities-panel	4	454	October 20, 2023
Convert string to date time Help activities , system	26	87235	June 10, 2022
How to convert date format from mm-dd-yy hh:mm to mm/dd/yy hh:mm Activities excel , activities , question	8	1901	January 18, 2022
How to convert a string in dd/MM/yyyy into MM/dd/yyyy hh:mm:ss in DateTime Format Studio activities , studio , question , system , tools	2	3340	May 25, 2021
I Want to Covert the String Variable Contain "09222023" to this Format 22.09.2023 Activities activities , studio , question	11	905	September 29, 2023

Convert date time format

Related topics