A
Annelie
I know it should be something like now() and?
but I can't get it
Help
Annelie
but I can't get it
Help
Annelie
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Tr
Between Date() and Date -
Date() give you just the dat
Now() give you date and tim
for this you just want the date
Good luck
Between Date() and Date -
Date() give you just the dat
Now() give you date and tim
for this you just want the date
Good luck
G
Guest
Opps, I meant 13 for two weeks
Between Date() and Date -13
Between Date() and Date -13
T
Tom Ellison
This may or may not be correct, depending on just what 2 weeks is.
Does it include all of today (so far) plus all the previous 13 days,
or all the previous 14 days? I'm guessing it may be the latter, in
which case you were closer the first time. Then there's the case
where the column for which you have this criterion may have a time
component. Even then it may be correct, but this may depend on the
exact meaning of 2 weeks. Is 2 weeks ago, when it is 10 PM, any time
back 14 days AND 22 hours? If so, there needs to be a further
adaptation.
The possible combinations of the meaning for 2 weeks is complex in
this way, and a thorough definition is worth thinking through before
proceeding. I know it seems intuitively obvious (and it probably is)
but computers are not very intuitive!
Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
Does it include all of today (so far) plus all the previous 13 days,
or all the previous 14 days? I'm guessing it may be the latter, in
which case you were closer the first time. Then there's the case
where the column for which you have this criterion may have a time
component. Even then it may be correct, but this may depend on the
exact meaning of 2 weeks. Is 2 weeks ago, when it is 10 PM, any time
back 14 days AND 22 hours? If so, there needs to be a further
adaptation.
The possible combinations of the meaning for 2 weeks is complex in
this way, and a thorough definition is worth thinking through before
proceeding. I know it seems intuitively obvious (and it probably is)
but computers are not very intuitive!
Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
A
Annelie
Actually I didn't need such specific data, I just want to minimize the data
displayed without the user having to input a date. I finally figured it out
myself.
Between Now() And Now()-14
Annelie
displayed without the user having to input a date. I finally figured it out
myself.
Between Now() And Now()-14
Annelie