Skip to main content
Question

lobby navigation, #TODAY#-10

  • September 24, 2026
  • 3 replies
  • 36 views
Do Gooder (Partner)
Forum|alt.badge.img+7
  • gope
  • Do Gooder (Partner)

Is this good or bad?

 

Navigation with query

page/ExternalVoucherLoadInformation/List;contexts=Company:13;$filter=(ExtLoadState ne IfsApp.ExternalVoucherLoadInformationHandling.ExtLoadState'Created') and (LoadDate > '#TODAY#-10')

Klick, get this

 

Press “Search” to view the query

Press blue “Search”, get a good result 

 

3 replies

Baran
Sidekick (Customer)
Forum|alt.badge.img+5
  • Baran
  • Sidekick (Customer)
  • September 24, 2026

hello Gope, 

Firstly, try just #TODAY# and see it works or not?

If this answer helped you, please mark it as Best Answer ⭐ IFS Consultant [LinkedIn](https://www.linkedin.com/in/baran-çelik-a2b2763a7?utm_source=chatgpt.com)
Do Gooder (Partner)
Forum|alt.badge.img+7
  • gope
  • Author
  • Do Gooder (Partner)
  • September 28, 2026

hello Gope, 

Firstly, try just #TODAY# and see it works or not?

That works but that’s not what I want. I want to find data in a timeframe of 10 days :-)

Baran
Sidekick (Customer)
Forum|alt.badge.img+5
  • Baran
  • Sidekick (Customer)
  • September 28, 2026

yes :) ı know. ı just wanted to be sure about that ıt work with just #TODAY#.

So can you try: TRUNC(LoadDate) >= TRUNC(SYSDATE - 10)

If this answer helped you, please mark it as Best Answer ⭐ IFS Consultant [LinkedIn](https://www.linkedin.com/in/baran-çelik-a2b2763a7?utm_source=chatgpt.com)
Terms & ConditionsAccessibility statement