convert decimal value in excel file in price columns and check date Column if date is greater then current date then Delete the full row in excel sheet. Book.xlsx (9.9 KB)

Hi @purnima_mandan How about this expression? DateTime.ParseExact(CurrentRow("Date").ToString,"MM/dd/yyyy hh:mm:ss",System.Globalization.CultureInfo.InvariantCulture).Date>Today Or DtOutput.Rows.Count>=1 Check out this XAML file Compare&DeleteRow.xaml (19.2 KB) Output Snap [image] To round of…

Excel file sheet

Help Studio

Gokul001 (Gokul Balaji) December 2, 2022, 7:40am 2

Hi @purnima_mandan

Can you share the expected output?

What do you mean by this? Can you tell us more details

Topic		Replies	Views
Question of excel Studio studio , question , activities_panel	15	1126	December 2, 2022
Need to filter out date column in excel file Studio studio , question , activities_panel	11	376	October 26, 2023
Date Compare Issue Activities excel , activities , question	30	5490	September 12, 2022
Compare excel date to today's date Help	20	3797	November 20, 2019
How to compare the current date with the excel file column Activities excel , question	34	892	October 13, 2023

Excel file sheet

Related topics