Search results

query.date (or table.date) is the original date that I want to modify. Imagine I have table which has 1 column (table.number) with a number and a second column (table.date) with date. I want to create a simple forecast, by adding some fixed number to our number column, and updating date by...

sorry for bumping old question: Basically, I would like my query to display the date+[form entered parameter]+number. If I wrote the following code into my query: .... some_date: query.date +5 .... it returns the result in "date" format. (original date+ 5 days) If instead I have the...

Hi, I am using a form [data_collect] to collect the data on starting date in my database. The text box is named start_date and I use "short date" format for it. When I then run a query that for instance includes a column end_date: Forms![data_collect]![start-date] +5 the results are...