@Santhosh_Hyd I have saw your post regarding date comparison is possible to help me in this scenario. Thanks
You can try this
Consider read the excel and store in dt1
Now use below linq query
DateDiff(DateInterval.Hour, CDate(Now.ToString(“yyyy/MM/dd HH:mm:ss”)),CDate(row(“Purchase Date”)))<=2 And Cint(row(“Amount”))>2). CopyToDataTable
The query works fine but I need the output based on repeating date also shown in Output window . could you please help me . The code you gave takes all the repeating value based on date
i am not cleared with question could you elaborate it please?
For eg if you take Input ID 0173 it has 3 rows but we need to filter and get Output based on repeating Purchase Date on same day and they are with in 2 hrs and amount less than 2$ so output will be only two rows for ID 0173
did u need to compare the purchese date with today’s date ?
not with todays date bro have to check and get those duplicate dates occurred in Purchase Date
with time diff of 2hrs time
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.