Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
two filter criteria a table should indicate a result. The criteria are Dat. and Status. If a date is selected, all records should be indicated before selected month. If in Listbox DATE "Mar 17" is selected all values before this criteria will be indicated. In additional with STATUS
In addition Listbox STATUS is also filtered.
Listbox Date should be group by MMM_YY.
Regards
Stefan
SUM({<Dat = {"<=$(=Date(Max(Dat),'DD.MM.YY'))"}>}Prod)
SUM({<Dat = {"<=$(=Date(Max(Dat),'DD.MM.YY'))"}>}Prod)
Thanks for your reply. If May 17 is selected, Apr 17 and previous month will be indicated.
How can I group month in listebox DATE?
Two possible solutions:
Best,
Peter
Check the attach.
Regards,
David
Thanks, it works fine
Which solution works fine?
Both versions works.
What means 100 in formula?
Dual(Date(Dat, 'MMM YYYY'), Year(Dat)*100+Month(Dat)) AS YMonth