can anyone tell me why this error come to send calender inivite activity
Pass the Start date as
DateTime.Today
but error is in start time and StartTime is excel column name
you can use cdate(YourString.split(" "c)(0).tostring)
This is because you can’t have the time value in there when converting as seen with 03:30:00
no try using cdate(CurrentRow(3).split(" "c)(0))
Replace the string with your current row
StartTime=DateTime.ParseExact(startDateTimeString, “dd-MM-yyyy HH:mm:ss”, System.Globalization.CultureInfo.InvariantCulture)
You got error because the data in the datatable contains one format like dd-MM-yyyy HH:mm:ss
But in DateT format is dd/MM/yyyy HH:mm:ss . Ensure the both have the same format.
I want to take value from excel column
StartTime
StartTime=DateTime.ParseExact(CurrentRow(3).ToString, “dd-MM-yyyy HH:mm:ss”, System.Globalization.CultureInfo.InvariantCulture)
Analyze it as described here:
[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum
Change variable type to System.DateTime
Remove double quotes and reassign double quotes
hyphen (-) vs /
in excel and StartDateTime i give - but again this error is come
In the above shared LINK to the firstAid it was introduced:
- Values in Excel are not mandatory in the same format as within the datatable
- Techniques for analysing within the immediate panel
- Approaches on how to solve e.g. handling multiple formats in one go
So we recommend
- got to the firstAid guide
- execute the different steps
Whenever there are some doubts, then:
- run some prototype code within the immediate panel
- share with us details from the debugging panels e.g. datatable content details
ashokkarale
Yoichi
Jacqui_M
aariz
TUSHAR_DIWASE
lrtetala
J0ska
sven.wullum1
lakshman
Speziman