Absence that are awaiting between pay period

Summary

Absence that are awaiting between pay period. Below query will identify all absence that is in awaiting status and are waiting for approval for a pay period

Content

Absence that are awaiting between pay period. Below query will identify all absence that is in awaiting status and are waiting for approval for a pay period

 

In the below case pay period is assumed from 1/5/2021 to 1/26/2021

 

Replace the date where it is highlighted with RED in the below query

Please replace Actual period start date in the query where ‘1/5/2021’ is mentioned

And replace actual period end date in the query where