report on account expire in 30 days

[Bijender]

Hi Team,

I am trying to create a flow designer to lookup list of users account expire in 30 days ( screenshot below )

But is it showing all the users whose account expire in 60 days and more.

Kindly advise how we can only show the account expiring in 30 days from today date.

Regards,
B

[Abhijit4]

Hi,

You have added condition like that. You need tell system to only fetch records where AD expiry date is exactly 3o days, not more than 30 days.

You can achieve it by adding condition something like below,

I did it for due date, you need to do it for 'AD Expiry Date'. If dates are not visible in screenshots then those are 29 and 31, so basically logic here is it will find AD Expiry Date after 29 days from now and before 31 days from now which returns Expiry date exactly on 30 days.

Let me know if you have any further queries.

Please mark this as Correct or Helpful if it helps.

Regards,
Abhijit
Community Rising Star 2022

[Abhijit4]

If your issue is resolved then please mark appropriate answer as Correct so that others can also gets benefitted from this.

Let me know if you have any further queries.

Regards,
Abhijit
Community Rising Star 2022