Hi,
iam reading the Excel to get the date and time value in a string format
and iwant only time value along with AM or PM. so iam using
datetime.ParseExact(read_time,“dd/MM/yyyy h:mm:ss tt”,system.Globalization.CultureInfo.InvariantCulture).ToShortTimeString but still iam not getting
where read_time is string variable
Please help me ASAP
Note: In Excel I have mentioned AM which is not visible in screenshot
Main.xaml (12.5 KB)
project.json (655 Bytes)
Hi @dhanushm,
Please refer the below expression
If you have a string like this in excel: “05/18/2019 8.30” and if you want only time value along AM and PM then use the below expression
Datetime.ParseExact(“05/18/2019 8.30”,“MM/dd/yyyy h.mm”,system.Globalization.CultureInfo.InvariantCulture).ToString(“hh:mm:ss tt”)
No still IAM not getting it is throwing error saying invalid datetime format
Hi @dhanushm,
Can you use the above expression in write line and let me know if you are getting any error.
Provide your Excel file.
Try the below one
Datetime.ParseExact(“5/18/2019 8.30”,“M/dd/yyyy h.mm”,system.Globalization.CultureInfo.InvariantCulture).ToString(“hh:mm:ss tt”)
In your scenario
Datetime.ParseExact(row(“Date/Time”).ToString,“M/dd/yyyy h.mm”,system.Globalization.CultureInfo.InvariantCulture).ToString(“hh:mm:ss tt”)
I want only time I don’t want date and my Excel Book1.xlsx (9.6 KB)
iam getting only time without AM/PM
Hi @dhanushm,
Have you used this expression
Datetime.ParseExact(row(“Date/Time”).ToString,“M/dd/yyyy h.mm”,system.Globalization.CultureInfo.InvariantCulture).ToString(“hh:mm:ss tt”)
And the error string was not recognized as valid date time because you are inside for each and for the 3rd row you have empty value under date column that’s y your expression is failing
no iam Not getting String was not recognized as a valid DateTime.
Does this resolve your issue?
no bro still iam getting error
it works well for me. is this what you wanted?
i also just changed the expression of the 2nd message box to
datetime.ParseExact(read_time,“dd/MM/yyyy h:mm:ss tt”,system.Globalization.CultureInfo.InvariantCulture).ToString
Hi @dhanushm
in Read Range activity can please check “PreserveFormat” and try it.
Regards,
Vijay Kumar C.
i think i need to reinstall my uipath studio … it didnt give me any error on the first 2 attempts but now
19.2.0+Branch.master.Sha.21b678a4c3a8b1362fcdd6e92496f991e5a7da37
Source: Message Box
Message: String was not recognized as a valid DateTime.
Exception Type: System.FormatException
An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
System.FormatException: String was not recognized as a valid DateTime.
at System.DateTimeParse.ParseExact(String s, String format, DateTimeFormatInfo dtfi, DateTimeStyles style)
at lambda_method(Closure , ActivityContext )
at Microsoft.VisualBasic.Activities.VisualBasicValue1.Execute(CodeActivityContext context) at System.Activities.CodeActivity1.InternalExecuteInResolutionContext(CodeActivityContext context)
at System.Activities.Runtime.ActivityExecutor.ExecuteInResolutionContext[T](ActivityInstance parentInstance, Activity1 expressionActivity) at System.Activities.InArgument1.TryPopulateValue(LocationEnvironment targetEnvironment, ActivityInstance activityInstance, ActivityExecutor executor)
at System.Activities.RuntimeArgument.TryPopulateValue(LocationEnvironment targetEnvironment, ActivityInstance targetActivityInstance, ActivityExecutor executor, Object argumentValueOverride, Location resultLocation, Boolean skipFastPath)
at System.Activities.ActivityInstance.InternalTryPopulateArgumentValueOrScheduleExpression(RuntimeArgument argument, Int32 nextArgumentIndex, ActivityExecutor executor, IDictionary2 argumentValueOverrides, Location resultLocation, Boolean isDynamicUpdate) at System.Activities.ActivityInstance.ResolveArguments(ActivityExecutor executor, IDictionary2 argumentValueOverrides, Location resultLocation, Int32 startIndex)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)
lets revisit the issue here.
is this correct?
yes bro
Hi @dhanushm,
There are so many solutions above which was created for your problem and each solution by everyone works, just learn from that and see where you are getting the error and change the expression accordingly.
If you are looking for the exact solution for your requirement you can Get the solution but can never understand the expression and based on errors only you have to learn.
Can you check the expression once again and see where is the error and learn the expression
@anil5 the expression shows that it is correct but i am not sure why i keep getting a error on it.
i will like to learn more on that and i hope it would be ok if you can share some thoughts on the same please 
Hi @VirajN,
Suppose we have this string “5/18/2019 8.30” and i want only time from this suppose 8.30 AM.
Datetime.ParseExact(“5/18/2019 8.30”,“M/dd/yyyy h.mm”,system.Globalization.CultureInfo.InvariantCulture).ToString(“hh:mm:ss tt”)
So if you want to convert a string which is representing a date and time to a different format you have to use Datetime.parseexact
“5/18/2019 8.30” - Any string with date and time format
“M/dd/yyyy h.mm” - We have to specify the format of this string “5/18/2019 8.30”
system.Globalization.CultureInfo.InvariantCulture - a parameter
ToString(“hh:mm:ss tt”) - Here i am specifying which format i want from the above string.
The output of above variable is a string variable.
Anil_G
ashokkarale
tolga.kamci
jpreziuso
Phenyo
vighneshgadekar
Josh_James
Basit_Xe
Jose_Corbalan
MasterOfLogic