Date + 3 days

[twac1382]

Ok, so I'm sure this is a pretty simple criteria, but I just can't seem to get the syntax right.

I'm trying to allow my user to select any start date and the query will return that date plus the next three days.

I appreciate everyone's help.

 

[plog]

What syntax have you tried?

 

[twac1382]

Actually, I think I just overlooked a simple spelling error.

I'm using:

Between [Enter Start Date] and DateAdd(d,3,[Enter Start Date])

Seems to be working now that I re-spelled it.

Thanks though.

 

[Brianwarnock]

Actually, I think I just overlooked a simple spelling error.

I'm using:

Between [Enter Start Date] and DateAdd(d,3,[Enter Start Date])

Seems to be working now that I re-spelled it.

Thanks though.

That is why you should always include your efforts, one's own syntax errors can be difficult to spot, but in this case you made it.

Brian

 

[Shuttlekilla]

=TODAY()+3

This a modified version of what I use to find all records within 30 days.
Below is the original version.

=TODAY()-30

Hope that helps

 

[Galaxiom]

Actually, I think I just overlooked a simple spelling error.

I'm using:

Between [Enter Start Date] and DateAdd(d,3,[Enter Start Date])

Seems to be working now that I re-spelled it.

That expression would not work in Access. The first argument of DateAdd() is a string and as such it should have double quotes around the d.

 

[Galaxiom]

=TODAY()+3

That won't work in Access either.

Date() would be the function you were thinking of.

 

[Brianwarnock]

That expression would not work in Access. The first argument of DateAdd() is a string and as such it should have double quotes around the d.

I thought that , but he said it was working so I decided I must be wrong and didn't check it, lazy I guess.

Brian