We are running Apps 10 Update 11
In the Aurena interface is there a way to search for a date that is say 3 days in the future? An example would be in Inventory Part In Stock and we want to find any items that expire in the next 3 days.
In IEE I would use the advances/SQL query and use something like EXPIRATION_DATE <= trunc(sysdate)+3
I’m trying to figure out how to replicate what we currently do in IEE in Aurena. Not that we are migrating to the cloud version immediately, but it’s going to happen sooner or later.
Solved
Aurena Advanced Search & Dates
Best answer by matt.watters
Try this, using the Y/M/W/D date search attributes for a Range.
In the screenshot below I will find all records for which the expiration date falls between today and the next 45 days.
Hi
You can get the same result you wanted as shown in the below screen print. You need to click on the Question mark and that will give you the conditions that you need filter the results.
Let me know if you need further assistance.
Kind regards,
Shanuka.
Hello again :),
Additionally you can turn on by clicking ‘Advanced’ as shown below.
Kind regards,
Shanuka.
+26Try this, using the Y/M/W/D date search attributes for a Range.
In the screenshot below I will find all records for which the expiration date falls between today and the next 45 days.
Thanks
+26BGunn wrote:
I assume you can do math in the fields, such as #TODAY#+60 or “#START OF THIS MONTH#-50. Never worked with the *, possibly a multiplier?
+2I tried variant (see screenshort). It not working
Only the option works
I tried the same thing W, Y, M ….
How does the filter “In range” work? What am I doing wrong?
+7Hi
Did you get any explenation on how the rage works? It would be nice to get it.
For me it looks like Y/M/W/D works like counting “from today”. I have search like at the picture below and 5M is converted to a date 5 months from today in Request URL.
I tried to do as you did (#START_OF_LAST_YEAR# + 5M) but it failed in application
Let me know if you have more information.
Br. Barbara
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.