I have a task to set a reminder date about expired insurance.
Insurance expired on 1 October 2022 (1/10/2022)
I have to output to excel 3 months before the insurance expired. So the robot will output to excel on 1 July 2022 (1/7/2022) every insurance that is expired on 1 October 2022. Any help on this?
try this Expression:
check = if(DateDiff(“d”,convert.ToDateTime(Now.AddMonths(-3)),Convert.ToDateTime(now))=90,“Not expired”,“Expired”)
okay what is that exactly you have to specify in the output excel?
Oh, the output will be “Insurance is 3 months left” or “Insurance is 1 year left” depends on the expire date of the insurance because it can be variety.
can you give me a screenshot of it in uipath flow? Thanks
Date.xaml (13.5 KB)
Please check the attached wf file
This is what I’m looking for. Thanks. 1 more thing, the insurance have different years of tenor. So the case is :
Customer A : Insurance Start 2017 and end on 2022
I have to output the reminder of each tenor (2018,2019,2020,2021,2020). Is this doable with your workflow?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.