var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Date Help
I have a Tbl that includes a review date. The review date that is manually inputted by the user. I need to have a query that returns those records that are within 14 day of the review date. Any ideas
The query criteria is: Between [InputDate] and Dateadd("d",-14,[Inputdate])
Thank-you, worked a treat
Well I thoughtit did work, but I seem to have become confused.
My table has a field that indicates when a review is due, it is formatted in short date order DD/MM/YYYY.
I need a query that returns all records that are within 14 days of the review date as indicated in the field ReviewDate.
The last post didn't seem to get up on the site. So here it is again. - Any ideas please?
Try the following as criteria for the review date field in the query:
> [YourReviewdatefieldname] - 14
in the criteria of whichever field logs the date of your report.