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

supermanPunch (Arpan) October 20, 2022, 4:28am 2

Hi @kowdfimls23 ,

Maybe some more detail would help us understand your requirement clearly.

Do you want to Check in the whole Column A or Do you want to just check in Cell A1 ?

Also, if Today’s Date is not found, In which cell would you want to enter the Today’s date value ?

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