Hi
Hope this expression would help you resolve this
—once after getting the datatable from READ RANGE activity named dt use a assign activity like this
dt = dt.AsEnumerable().Where(Function(a) a.Field(of String)(“yourcolumnname”).ToString.SubString(0,10).Equals(Now.ToString(“dd/MM/yyyy”)).CopyToDatatable()
Cheers @Shubham_Akole
@Shubham_Akole Check this workflow, Hope You can understand this 
GetEmployeesHavingBirthdayToday.zip (7.1 KB)
The variable AllEmployeeNames will contain the names of All Employees
the .xml file is empty
@Shubham_Akole Sorry for that GetEmployeesHavingBirthdayToday.zip (7.6 KB) , Check this Workflow :
suppose i have to run this workflow on other machine …so we can done this
this system does not contain these excel file…and no ui path studio…
@Shubham_Akole Run it in the System which has UiPath Studio and the Excel File, You just need to Change the Path Name in Read Raage
Hi,
I see the workflow is blank that you have attached. Can you attach one more time?
Thanks
only contain ui robot it is not possible?
or by using orchestrator it is not possible…
Hi @Shubham_Akole,
If you dont have Excel in system,you still can run using Workbook Read Range activity,
Excel application scope activity wont work if dont have excel in your system.
Orchestrator is to run our workflows from Web,but UIPath should be installed in our PC as mandatory.
@Shubham_Akole If it contains only UiRobot, You first need to Publish the Package and get the .nupkg file , This File you need to Put it in a Specific Folder
Assign: Conversion from string “20870” to type ‘Date’ is not valid.
Hi,
It’s giving the correct output. Thank you. Can you please tell me how to insert the output names in an Excel, tried doing. But it’s not working
Thanks,
Anuradha P.
@anuradha_puligoti Use write cell Activity in Excel Application Scope to insert output name in Excel.
In Range ,give where you want to insert data.
@Shubham_Akole There’s some problem in your Excel File, You can send me the Excel File in my Inbox, I can Check what’s the Issue, It has soomething to do with OADate but not quite sure why that value you get
@anuradha_puligoti What do you mean by output Names? If you’re using the variable AllEmployeeNames from my Workflow and trying to insert it into Excel using Write range, it won’t work, baecause the type is string and it needs a Datatable
asenumerable is not a member of system.data.datatable
these error…
Asenumerable is not a member of system.data.datatable
Hi
Kindly include this assembly reference by opening main.xaml in a notepad
Cheers @Shubham_Akole
Read Range: The specified package is invalid. The main part is missing.
how solve this error
Can I have a screen shot of it
@Shubham_Akole