4 days prior to Last day worked date field

[TejashviT]

Hi Community,

Good Day !

 I have to trigger notification based on the condition "4 days prior to Last day worked date field" . I tried multiple things in condition builder but nothing is working fine. It returning unexpected records.

Please guide me how can build this condition in condition builder and use to trigger notification.

I also have attach the screenshot for the condition builder , I am using .

Thanks in advance 🙂

[Chaitanya ILCR]

Hi @TejashviT ,

your condition is correct but just check if there any records exist 

assuming you are talking about sys_user table records 

( I doubt if any records exist because the last day is usually not populated until the employee has left the company or only populated on the last working day) this what usually organizations follow to hide this offboarding information till employee leaves

just put a condition the last day worked is after today see if you find any records 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[TejashviT]

Hey @Chaitanya ILCR 
Thanks for the reply. 
I do have records and also this field is populated also.
The issue here is , if I am applying the above mentioned conditions I am getting all records , means, if have set Last day worked to 19May for one record and for another record to 22nd May, when I am running filter I am getting both records. As my requirement , I should only get one record.

If you can achieve me getting only record using the condition builder then will be grateful to you.

Again thanks in advance 🙂

[Vishal Jaswal]

Change relative after to relative on 4 days from now.

[TejashviT]

Hi @Vishal Jaswal ,
I need exact the same record which is prior to 4 days from the date mentioned in "Last day worked field".
These filter conditions are giving me 4 and less than 4 days record.

Hope I am clear to my doubt