Creating a Dynamic Date Filter and Flag the Missouts

[DataPirate26]

Hi All,

Below I have shared a Dataset. In the Provided dataset Hours are being clocked for Each Working days. The weekends are excluded and not being clocked so the dates will be missing as well . I have to check for Each Employee against each date(Working days) if he has clocked a minimal of 8 hours or not . If the hours are less than 8 and the candidate has not clocked any hours for that day that needs to be Flagged. 

Note: For a particular date a person can clock Time for Separately for various Tasks. The cumulative sum of the hours need to be 8 for a particular date. 

Also a Dynamic Date Filter needs to be created which will help us to Filter out Last 3 months data from Today's Date. 

[DataPirate26]

@DataNath Worked perfectly. I was Selecting the text input Due to some reason it was not taking up. Thanx a lot.

[DataPirate26]

@DataNath Worked perfectly Fine. Thanx a lot for all your assistance