Hello, I need help I want to create a function where an Excel file with date column (A1) and time column (B1) is called and then checks if today’s date is already entered in column A1. If yes, the function should end, if no, it should enter today’s date and the current time. Can anyone help me wit…

@kowdfimls23 , Maybe you could try out the below Steps : Read the Excel Sheet Data using Workbook Read Range Activity. Get the Output as Datatable, say DT. Find if there is a Date corresponding to Today’s Date using a Linq like below : Not(DT.AsEnumerable.Any(Function(x)CDate(x(0).ToString…

Create Excel file that checks today date in column

Help Studio

kowdfimls23 October 20, 2022, 5:32pm 7

I chose the write cell method
It worked perfectly - thanks again for your help!!

1 Like

Topic		Replies	Views
Function that checks today date Studio datatable , excel , uiautomation , studio , question , activities_panel	5	546	November 15, 2022
Create Sheet with todays date if not Present Studio datatable , excel , uiautomation , orchestrator , activities , studio , question , activities_panel	6	487	February 17, 2023
Data table that has date field Help datatable , excel , activities , question	8	949	December 5, 2019
Write data in an excel according to the current date Studio excel	3	941	November 13, 2020
Today Date excel file every day updated Something Else feedback	5	754	July 17, 2022

Create Excel file that checks today date in column

Related topics