I am new and excuse my limited english. I’m building an inventory management system for vehicles. There is an Inventory table “Bestand” with columns
[Source],[Date-1.EK],[Date-2.EK],[Date-EK],[Source2][Date-1.VK],[Date-2.VK],[Date-VK],
I have a filter with a start and end date. I would like to filter the date in the period and show lines depending on “source”. My structure: FILTER (“inventory”,
AND ([Date-EK]> = [Filter-Start], [Date-VK]> = [Filter-Start], [Source] = “Other”,
OR ([Date-EK] <= [Filter-End], [Date-VK] <= [Filter-End], [Source.] = “Other”
)))
I get no further to determine that all dates are seen sorted and compared to “source”. my simple formula is too inadequate and I couldn’t find anything suitable in the help. I am really grateful for any help.
LinkedIn
Twitter
