Add date range to AOT query (days difference)

Like (2) Share

Report

Posted on 27 Dec 2022 14:53:06 by Suren_G

242

Hi,

We have a requirement to add range to a AOT query to filter the VendInvoiceJour records that has the posting date lesser than 10 days from the current date.

Could anyone provide details on how the range can be added in this case.

Thanks!

All responses (6)

Answers (1)

Suren_G 242 on 30 Sep 2024 at 07:34:27

Like (0)

Report

Add date range to AOT query (days difference)

..
Vijay Yelmame VY 446 on 28 Dec 2022 at 19:25:03

Like (0)

Report

RE: Add date range to AOT query (days difference)

Hi Suren,

(GreaterThanDate(-10)) is exactly same as (LessThanDate(10)).

You can check both.
Suren_G 242 on 28 Dec 2022 at 13:43:21

Like (0)

Report

RE: Add date range to AOT query (days difference)

Hi Vijay,

Thanks for your response. (GreaterThanDate(-10)) range value works. But we're facing one other issue which is different. Will create a separate thread for that.
Suggested answer

Deepak Agarwal 8,566 on 27 Dec 2022 at 16:58:27

Like (0)

Report

RE: Add date range to AOT query (days difference)

It seems you want to modify a form view for the end user. You can try to achieve this by changing the form view on the front end and saving it. If I understand this correctly, you can avoid customization here.
Verified answer

Vijay Yelmame VY 446 on 27 Dec 2022 at 15:13:28

Like (1)

Report

RE: Add date range to AOT query (days difference)

Hi Suren,

below is also another approach, you can try and let us know.

(LessThanDate(7))
GirishS 27,823 Moderator on 27 Dec 2022 at 15:03:43

Like (0)

Report

RE: Add date range to AOT query (days difference)

Hi Suren G,

Try like "(today() - 7)" on the range value. I never done like this, and I am not sure it will work.

But give it a try.

Thanks,

Girish S.