IS there any way I can add DateDiff to the fetching query???

Hi Amith,

Here is how you can achieve that:

Using DateDiff: http://llblgen.com/TinyForum/Messages.aspx?ThreadID=12118&StartAtMessage=0&#67278

A little complex retrieval (DateDiff + DateAdd + CustomFilter on relation): http://llblgen.com/TinyForum/Messages.aspx?ThreadID=13766&StartAtMessage=0&#76737

(in future posts, please provide more info )