Find the date category which falls between 2 dates - Please see description

Attached Spiotfire file.

I want to find the category based on dates entered by user.


For eg if I am entering the date 03/02/2016 it should fall under category "A" since category A belongs to dates between 03/01/2016 and 03/05/2016.


Kindly help.



Binary Data find_date_category.dxp153.72 KB

(1) Answer