Drawing Data between 2 dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I would be grateful for some help. I need to draw data between 2 dates, based on the same field "AssDate". According to another post, the following should work:
BETWEEN [Enter the AssDate] AND [Enter the AssDate]

When I use this expression however, only one dialogue box pops up, so I can only insert the first date and not the second. Can anyone give me some advice.
 
Use two parameters with different names:
BETWEEN [Enter first AssDate] AND [Enter last AssDate]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Andre Skeen said:
I would be grateful for some help. I need to draw data between 2 dates,
Click to expand...
based on the same field "AssDate". According to another post, the following
should work:
BETWEEN [Enter the AssDate] AND [Enter the AssDate]

When I use this expression however, only one dialogue box pops up, so I
Click to expand...
can only insert the first date and not the second. Can anyone give me some
advice.
 
Thanks, that did the trick!
--
Andre Skeen


Allen Browne said:
Use two parameters with different names:
BETWEEN [Enter first AssDate] AND [Enter last AssDate]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Andre Skeen said:
I would be grateful for some help. I need to draw data between 2 dates,
Click to expand...
based on the same field "AssDate". According to another post, the following
should work:
BETWEEN [Enter the AssDate] AND [Enter the AssDate]

When I use this expression however, only one dialogue box pops up, so I
Click to expand...
can only insert the first date and not the second. Can anyone give me some
advice.
Click to expand...
 
Back
Top