Uipath date format conversion | Convert string to date time format | DateTime Comparison UiPath #39

This video provides a complete guide on DateTime variable of UiPath
Learning:
How to fetch current date time in UiPath
Date Time format conversion
How to add/subtract time in UiPath
Convert string to date time format
Complete demo - Fetch date time data from excel as String - Convert string to date time format - Perform date time operations - date time comparison UiPath
=========================================================
Automation Anywhere Tutorial Playlist:
• Automation Anywhere A1...
Automation Anywhere A2019 Tutorial Playlist:
• Automation Anywhere A2019
UiPath Tutorial Playlist:
• UiPath Tutorial
JMeter Tutorial Playlist:
• JMeter Tutorial
Git and GitHub Tutorial Playlist:
• Git and GitHub Tutorial
Subscribe for more tutorials - / @qualityassurancelab7764
Connect with me for some interesting updates here -
LinkedIn - / quality-assurance-lab-...
Facebook - / quality-assurance-lab-...
Twitter - / labassurance
Medium - / labassurance
Join Channel Membership - / @qualityassurancelab7764

[@qualityassurancelab7764]

Hi Guys! Hope you found this video useful. Please like, share and subscribe to my channel. This will motivate me to create more good content. Thanks!

[@andyyeo5757]

Great and useful video, thank you.
Question:
I created this variable: StartDate as DateTime variable and assign to: DateTime.ParseExact(strUserInputDate,"dd/MM/yyyy",System.Globalization.CurrentInfo.InvariantCulture)
strUserInputDate is a string variable containing the user input of a date in this format: dd/MM/yyyy
Let's say the user inputs: 31/12/2022
When I do a Write Line for StartDate, it shows: 12/31/2022 which is MM/dd/yyyy format
How can i output: 31/12/2022 instead of 12/31/2022?

[@sangitaandhale1673]

Like i have the Excel and it has the date format MM/dd/yyyy and dd/MM/yyyy so bot take the date from Excel but how to know the bot this is MM/dd/yyyy format.
When the date 01/07/2022 and 07/01/2022 in that case bot not provide me the correct date format it take Excel value as it. But when day or Month greater than 12 in that case it will work bot identify which is day and which month
I need to work bot in case when day and month less than 12 and result date in MM/dd/yyyy format
Could you please suggest me some on this

[@sudiptaghosh2195]

Nice!! helpful content :)

[@mihaeladraghici7108]

great demo, thank you

[@the_snake2506]

Im getting timestamp in the datetime variable, how can i remove the timestamp?

[@adityasrinivas212]

Thanks a lot.

[@prabhukiran7866]

Hi Team
im getting below error while converting the String to Date format. any suggestions how to get over this..?
Error: Assign: String was not recognized as a valid DateTime.

[@UserJsrl2024]

Kindly create variable properly

[@arunwaghmare5193]

write range which you passed is A1 instead of C2

[@bhavanichenneboina1672]

hello mam please respond to mail...regarding automation anywhere v11 version

[@qualityassurancelab7764]

Hi, I have replied