Hello,
The problem I have might see very simple but I cannot get past it and am stuck.
The situation is the following:
There is a column with dates with "Date/Time" data type (and Short Date format). In a query I want to display all records which are 14 days later from the assigned date (there are different dates for each record).
I have tried with the following expression in the quety criteria ("InvLetDate" is the name of the column with the dates that are being checked):
DateAdd("d";14;[InvLetDate])
With this expression I receive always no results although there should be some.
What am I doing wrong
Please help