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

purnima_mandan (purnima mandan) December 2, 2022, 8:04am 4

sorry this was my mistake in salary colume we have to convert decimal value

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