How to check if the date format is less than or greater than particular date

Help
1

Hi,

how to check the date in excel column is less than or equal to 1/1/1995 (date format in this scenario 1/1/1995)

2

@srujanch,

you can read the data from the excel by using read range and you can use Date.compare(“date1”,“date2”) method which will return an integer value of -1,0, or +1.

0- when dates are equal
-1 - when first date is less then sencond
+1 - when first date is greater then second.

Hope this helps.

Thanks,
Sid

4 Likes