DateTime Formats and Conversions in UiPath
In this article you will find all that you need to work with DateTime Formats and conversions.
Formats:
Hour (12-hour clock) -> h ex: 6, hh ex:06
Hour (24-hour clock)-> Must be capital always. H ex:13, HH ex:20
Minutes -> m ex: 2, mm ex: 02
Seconds -> s ex: 2, ss ex:03
Time->This is for AM and PM. t ex: P, tt ex: PM
Day in number-> d ex: 6 from 1-31 day of month, dd ex: 22 from 01 -31 day of month
Day in string ->ddd ex: Sun, dddd ex: Sunday
Months->Must be capital always. M ex: 7, MM ex: 07, MMM ex: Jul, MMMM ex: July
Year->y or yy ex:20, yyy or yyyy ex:2020
Time Zone -> K ex: +04:00, z, zz, zzz ex: +4, +04, +04:00
Examples for different formats in UiPath
Example 1:
Input:
Output:
Example 2:
Input:
Output:
Example 3:
Input: Current system date
Output:
Example 4:
Input: Current system date
Output:
Example 5:
Input: Current system DateTime with Time zone
Output:
Example 6:
Input: System DateTime which displays AM or PM
Output:
DateTime Properties:
There are several properties like Day, Month, Year, Hour, Minute, Second, DayOfWeek and others in a DateTime object which can be retrieved.
Example1:
Input:
Output:
Adding DateTime:
Below are the methods available in UiPath for adding DateTime:
Example1:
Input:
inputDate=”4/22/2020 3:30:20”
Convert.ToDateTime(inputDate).AddMonths(3).ToString(“MM”)
Output:
Subtracting two Dates:
Example1:
Input:
inputDate = “10/22/2020 3:30:20” or Convert.ToDateTime(“10/22/2020 3:30:20”).ToString(“MM”)
CurrentDate= Now.ToString or Convert.ToDateTime(Now).ToString(“MM”)
Output:
convert.ToDateTime(inputDate).Month-convert.ToDateTime(Now).Month
or
Convert.ToInt32(inputDate)-Convert.ToInt32(currentDate)
Example2:
Input:
inputDate and currentDate of type System.DateTime
Output:
Convert DateTime to specified type:
Methods available are ToBinary, ToOADate, ToLongDateString, ToShortDateString, ToLongTimeString, ToShortTimeString, ToString, ToUniversalTime, ToFileTime, ToLocalTime
Example 1:
Input:
inputDate =Convert.ToDateTime(“10/22/2020 3:30:20”).ToShortDateString
Output:
Example2:
Input:
inputDate = Convert.ToDateTime(“10/22/2020 3:30:20”).ToShortTimeString
Output:
String to DateTime Conversion in C#
There are two methods available:
Depending on your requirement you can
DateTime.Parse: This method is used to convert string date time representation to DateTime object.
Value: It is string representation of date and time.
Provider: It is an object which provides culture specific info.
For example: System.Globalization.CurrentInfo.CurrentCulture
Styles: It defines the formatting options that customize string parsing for some date and time parsing methods.
DateTime.Parse(String value, IFormatProvider provider, DateTypeStyles styles)
Example1:
Input:
Output:
DateTime.ParseExact: This method can be used when you want to get exact format of date. There are different arguments which you need to pass while converting to a format.
Value: It is string representation of date and time.
Formats: It is format specifier that defines a date look like after conversion. For example: “dd/MM/yyyy”
Provider: It is an object which specify culture info.
For example: System.Globalization.CurrentInfo.CurrentCulture
Style: It defines the formatting options that customize string parsing for some date and time parsing methods.
DateTime.ParseExact(string value, string[] formats, IFormatProvider provider, DateTimeStyles style)
Example 1:
Input:
Consider your Input: string in below format:
Output:
Timespan in C#:
Example1:
Input:
inputDate and currentDate type as DateTime and timeSpan type as TimeSpan
Output:
Example2:
TimeSpan class provides FromDays, FromHours, FromMinutes, FromSeconds, and FromMilliseconds to create TimeSpan objects from days, hours, minutes, seconds, and milliseconds and add, subtract, negate methods to add, subtract, negate methods
Input:
Output:
We hope you enjoyed the article!!
You can connect with Kishori Afzulpurkar, she is always happy to help. 🙂
Thank you!!
