Report for filtering for dates to come within 2 weeks

[Nisha30]

Hi,

I have  a table which contains date/Time field (FieldA) and I want to create a report to show me the records in which the field A is 2 weeks or 2 months from now Purpose is so that we know the date is approaching within this time to act upon.. What operator could give this (Is it relative before or after not sure)

Thanks

[Nisha30]

So actually example we want to act for the records which are within 2 weeks from now . So if today is 22nd June so records where fieldA has 6th JUly and not the ones which are in August coz those are still far away and we need 2 weeks or a definitive time it can be 2 weeks / 1 month / OR constant x amount of time.

When I am giving relative after 15 days from now it shows me all which are after 15 days including the ones which are 3 months later.

Thanks

[Suseela Peddise]

Hi,

You can apply relative filter on date/time field. Below is the example query , please change the field and conditions according to your requirement. Use 'after' .

If I have answered your question, please mark my response as correct and/or helpful.

Thanks,

Suseela P.

[JagjeetSingh]

Hi,

As per the scenario you have described. You have to use relative operator with before condition.

Check and let me know if this works for you.

[Nisha30 · Accepted solution]

Hi Jagjeet,

This gives me including of month MAY or March I mean the ones prior to todays date as well.

Thanks