Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

DATEADD (or similar) in calculated field in view (embedded db)

hi

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.

Is this possible in 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?

DATEADD (or similar) in calculated field in view (embedded db)

hi

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.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?