Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Greetings,
i have a question regarding following problem:
I have a simple table with a date field named Dat_LS and several other fields showing articels which have been delivered to customers and their amount.
Dat_LS shows the date, on which the article is delivered to the customer.
Dat_LS | LS_Number | Article | Description | Amount |
---|---|---|---|---|
28.Okt.15 | 900000 | 1 | Test1 | 6,3 |
27.Okt.15 | 900008 | 3 | Test3 | 2 |
26.Okt.15 | 900009 | 6 | Test6 | 7 |
25.Okt.15 | 900010 | 6 | Test6 | 4 |
What i want to do now but fail to acomplish by myself is to create a listbox or button, which selects all date equal or smaller to the current date.
Lets say its today, 27.10.2015. When i click the button, a filter should be applied to only show all the articles delivered until the 27.okt.15. (something like [select all dates <=today()])
Can anyone offer an idea how to realize this?
I have found the solution in another post:
The correct Syntax for the Trigger in the listbox is
='=Dat_LS<=today()'
If i want to only Show the dates until yesterday:
='=Dat_LS<=(today()-1)'
The Post with the original answer can be found here:
Re: Show Dates Less Than or Equal to Selection
Thanks to Brandon Breitling for the easy solution, and sorry for opening a new post to an already solved Problem.