Share
Report
20Hi Everyone, I hope you doing well. I'm working on new flow that need to do the outcome bellow:
- I have the employees master list that will contain many information including if the employee name, status if still active or no, Driver License expiration date, and safety certification expiration date.
- What I need to achieve is every Monday an email will be send to supervisors that will contain in separate fields with employees name who will have Driver license and safety certification will expire in 30 days or less.
as this point I did create the flow with filter query that will filter the active employees (which is working) but the expiration date will never works.
here is the flow
here is the outcome when I did (ge) (Greater than or equal to) in the DL expiration date expression
when I tried the (Less than or equal to) (le) I got this output
I need the email contain only the employees who have their DL expire from today until 30 days from now (all in between these dates).
Thank you,
All responses (
Answers (
