Check multiple cafeterias

OCM · #8 05-20-2020, 06:07 AM

ArviLaanemets, thanks.

Quote:

From your workbook example, it looks more like you want to get all codes for ID when in week around/after of H0004 aren't any other codes, not codes for one week

Correct, the goal is to identify if a given ID/individual has H0004 and then gets any other codes within 7 days intervals.
e.g. individual gets H0004 code on 5/1/20 and then gets G0400 on 5/6/20, then the way it’s done manually is to get the difference i.e. 6-1= 5 days. Then we flag this as it is <= 7 days and not allowed.

But, say if individual gets H0004 on 4/7/19 and gets G0401 on 4/18/19 then it’s allowed (18-7=11 days) over 7 days intervals and we do not need to flag this ID/individual.

Quote:

Are you meaning week as calendary unit, or as 7-day time period?

7-day time period

Quote:

When week is 7-day time period, then does it apply to dates before and after H0004 (13 days total), or only for dates after H0004 (7 days total)?

Only, dates after H0004 (7 days total)

Quote:

Must all conditions apply for all H0004 codes for same ID, or only for latest one (e.g. what happens when in year 2018 was H0004 with another code in next day, but in year 2019 was H0004 without any other code less than 7 days apart)?

To clarify & simplify things, let’s say we have 4 codes:
H0004 (main code)
G0400
G0401
80008
Simply put, H0004 code cannot be followed or combined with any of the other 3 codes within 7 days. But, H0004 code by itself can be provided daily or at any time (no restrictions)

In your example,
a. if in year 2018 H0004 with another code the next day= not allowed
b. in year 2019 H0004 without any other code less than 7 day apart = allowed

Quote:

How must rows with no dates handled?

Usually, the date field is almost always populated

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select multiple check boxes at once.	Batchook	Word	0	09-08-2016 03:44 PM
Excel vba to check to check if two columns are empty	subspace3	Excel Programming	5	07-09-2015 04:45 PM
Multiple Check In/check Out Times	big0	Excel	4	09-19-2013 05:02 AM
cannot check/uncheck check box but added check box	learn2office	Word	1	11-27-2012 02:02 AM
Link word check box to access check box	Mrkieth	Word	4	01-30-2012 06:43 AM