Jump to content
Sign in to follow this  
ddave

finding missing dates

Recommended Posts

I'm working with a file that contains these fields: 'User' (text), 'Week of'(date). In the 'Week of' field is the date of the Sunday of that week.

Sam 3/3/2002

Sam 3/10/2002

Sam 3/24/2002

Sue 3/3/2002

Sue 3/24/2002

How can I show the weeks that Sam and Sue forgot to enter for the month of March? I think I could do this in a script looking at each record and marking where the date in the current record = 7 more days than the date in the previous record (although I'm not sure how that would work in Sue's case where she missed two weeks in a row). I was hoping a relationship could somehow be established so the user could see their missing dates in a portal. I thought about having a related file with all the weeks of the year but I don't see how I can connect the two.

Thanks for any help!

ddave

Share this post


Link to post
Share on other sites

When the user creates the new record which records them as entering data, you could have it check how many days since the previous record - as you said.

Then if this is greater than 7, have the script create new records with "MISSING_ENTRY" in a field. It would create a new record for each multiple of 7. Then use the user name & "MISSING_ENTRY" as the key in a self relationship to show the missing dates in the portal you decribe.

Russ

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.