NOW Report

[Ganesan5]

I have a date field with a future date, for example, a Rate Renewal Date. I need to generate a list showing how many records will be due for renewal six months from now. If I run the job on the first day of each month, how many records will be due for renewal in six months?

is this correct? where it will show me all the records for the 6th month?

[MS25]

Filter you have there seems to be correct. Just make sure you have AND between these two conditions. 

Please mark this answer helpful and correct if it helps you so others can benefit from this answer.

[AndersBGS]

Hi @Ganesan5 ,

Why not utilize below: (6 months from now)

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[Ganesan5]

Hi Ander, I can use that if I am doing this check daily, but that will list all the records after falls 6 months from.

As for my use case, we planning to run this monthly to show all the records falls under 6th month, from 1st day to last day of that month.