Entering current date in input box

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

Guest

Hello,

I have an input boxes that come up as a result the synatx 'Between [Enter
Start Date] And [Enter End Date]' against criteria under the field 'Date' in
one of my queries. It is working fine, but I want to avoid the monotony of
having to enter both the start and end date if they both happen to be the
current date. I was just wondering if it would be possible for the current
date to the automatically inputted for both entry requirements by a double
click of the mouse in the input boxes.

Thanks for your expected usual support.

Alylia
 
No double click, but you just hit return instead of entering anything in the
parameter request.

Between Nz([Enter Start Date],Date) And Nz([Enter End Date],Date)

And if you just wanted to enter the start date and have the end date
default to the entered start date

Between Nz([Enter Start Date],Date) And Nz([Enter End Date],Nz([Enter
Start Date],Date))
 
Thank you for your prompt response.

I tried the syntax "Between Nz([Enter Start Date],Date) And Nz([Enter End
Date],Date)" and it has not worked. It give me the error msg "this expression
is type incorrectly or is too complex to be evaluated". I also noticed that
the syntax changes to Between Nz([Enter Start Date],"Date") And Nz([Enter End
Date],"Date") when I run the query.

Thanks for your continued support.


John Spencer said:
No double click, but you just hit return instead of entering anything in the
parameter request.

Between Nz([Enter Start Date],Date) And Nz([Enter End Date],Date)

And if you just wanted to enter the start date and have the end date
default to the entered start date

Between Nz([Enter Start Date],Date) And Nz([Enter End Date],Nz([Enter
Start Date],Date))


Alylia said:
Hello,

I have an input boxes that come up as a result the synatx 'Between [Enter
Start Date] And [Enter End Date]' against criteria under the field 'Date'
in
one of my queries. It is working fine, but I want to avoid the monotony of
having to enter both the start and end date if they both happen to be the
current date. I was just wondering if it would be possible for the current
date to the automatically inputted for both entry requirements by a double
click of the mouse in the input boxes.

Thanks for your expected usual support.

Alylia
Click to expand...
Click to expand...
 
My error. I should have used Date() instead of Date. I forgot the Parens
to make the database recognize that I was using the Date function

Between Nz([Enter Start Date],Date()) And Nz([Enter End Date],Date())



Alylia said:
Thank you for your prompt response.

I tried the syntax "Between Nz([Enter Start Date],Date) And Nz([Enter End
Date],Date)" and it has not worked. It give me the error msg "this
expression
is type incorrectly or is too complex to be evaluated". I also noticed
that
the syntax changes to Between Nz([Enter Start Date],"Date") And Nz([Enter
End
Date],"Date") when I run the query.

Thanks for your continued support.


John Spencer said:
No double click, but you just hit return instead of entering anything in
the
parameter request.

Between Nz([Enter Start Date],Date) And Nz([Enter End Date],Date)

And if you just wanted to enter the start date and have the end date
default to the entered start date

Between Nz([Enter Start Date],Date) And Nz([Enter End Date],Nz([Enter
Start Date],Date))


Alylia said:
Hello,

I have an input boxes that come up as a result the synatx 'Between
[Enter
Start Date] And [Enter End Date]' against criteria under the field
'Date'
in
one of my queries. It is working fine, but I want to avoid the monotony
of
having to enter both the start and end date if they both happen to be
the
current date. I was just wondering if it would be possible for the
current
date to the automatically inputted for both entry requirements by a
double
click of the mouse in the input boxes.

Thanks for your expected usual support.

Alylia
Click to expand...
Click to expand...
Click to expand...
 
Back
Top