Between the dates

[Scheruku]

Hi All,

We have challan and entry date for the vehicles.. We are trying to find out if the same vehicle has entered again (entry time) between the challan and entry time.

For ex - the vechicle has challan time of 20-07-2018 and entry time of 25-07-2018, and for the same vehicle do we have entry time between the dates, like 21-07-2018 which should not happen...

Veh	Challan	Entry
12345	05-07-2017	07-10-2017
12345	06-07-2017	06-07-2017	Flag
16782	02-07-2017	05-07-2017
16782	05-07-2017	05-07-2017
16782	05-07-2017	04-07-2017	flag
16782	12-07-2017	13-07-2017

Best Regards,

[vishwa_0308]

Hi @Scheruku,

For each vehicle everytime the Entry Date will be greater in the next row. Here is the formula:

In Multi-row formula tool use below formula grouping by vehicle.

if [Entry]>=[Row-1:Entry] then "" else "Flag" endif

Thanks,

Vishwa

[mceleavey]

Hi @Scheruku,

I've built a workflow that does it for you.

Let me know if it works.

M.

[Scheruku]

Hi @mceleavey,

Thank you for your help... I was able to run the workflow but it wasn't throwing me the exeptions..for example

Row No 6 has an entry date of dd-mm-yyyy(07-01-2018) but the same vehicle has an entry date prior to it on the above rows... We are saying the vehicle has prior date because it falls between challan and entry time of the that particular row

challan - 23-09-2017 Entry 07-01-2018

The above row has an entry date between these two dates i.e, 05 & 01 ...and these two rows have to be flagged  

Veh	Challan	Entry
B8933	29-07-2017	30-07-2017
B8933	26-12-2017	27-12-2017
B8933	30-12-2017	31-12-2017
B8933	02-01-2018	02-01-2018
B8933	04-01-2018	05-01-2018
B8933	23-09-2017	07-01-2018
B8933	08-01-2018	09-01-2018

[danrh · Accepted solution]

Does something like this do the trick?