Graph and exportable table showing expired data

[AaronJ]

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? 

[CoopperBackpack]

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.