I want a drop down to select one of the eight days from one week ago till today.
So I created a table with the integers 0…7 in column N, and tried to create a view with the calculated column subracting N from today’s date. I have used today() - N AS WKDATE to do the similar in Ms Access.
Is this possible in base with the embedded db? I cant find a syntax that the view builder will accept.
If this technique is not possible, any suggestion about how I would create such a drop down box that automatically shows today’s date and the previous seven dates?