Jump to content
  • 0

Graph and exportable table showing expired data



Hi All,

I am building my database to hold staff training records, I would like to be able to create a graph/report that shows the staff who have expired training dats (over 12 months) Cant seem to see how to do it, any ideas? 

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hello @AaronJ,

If my understanding is correct, there is a training date in the table and it is individual (the date depends on the particular employee).

You may check the following approach:

1) Create a new Date/Time field. In my example its name is 'Training_Date_Exp':


2) This field can be populated by a Task that runs daily:


The logic is to add the date if 12 months have passed.

For today, after the Task run, the result is:



3) As a next step you may either create a View that filters records where the  'Training_Date_Exp' field is not blank and build the DataPages based on this View. Or you may filter records directly on the DataPage if the Search is not needed.



If you need a different result, please provide more details.

Link to comment
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.

Answer this question...

×   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.

  • Create New...