Dates

[jeannette_rivera]

I already had a text box with this info: =" Between "&[Enter Start Date]&"
And "&[Enter End Date]" and it works perfectly but I would really like to do
some format to those dates. Right now if I type 8/1 or 8/1/5 or 8/1/2005 it
shows the date as I type it.
I would like to format this to always show the date as M/D/YYYY

Thank you all!

 

[Duane Hookom]

Use the Format() function to display most any data type in a particular
format. Check Help if you have questions.

 

[jeannette_rivera]

=" Between "&[Enter Start Date]&" And "&[Enter End Date]"

Where in this statement shoul I use Format()?

Can you tell me how exactly I should do it?

Thank you for the quickly reponse in this post...

Use the Format() function to display most any data type in a particular
format. Check Help if you have questions.

--
Duane Hookom
MS Access MVP
--

I already had a text box with this info: =" Between "&[Enter Start Date]&"
And "&[Enter End Date]" and it works perfectly but I would really like to
do
some format to those dates. Right now if I type 8/1 or 8/1/5 or 8/1/2005
it
shows the date as I type it.
I would like to format this to always show the date as M/D/YYYY

Thank you all!

 

[Rick B]

=" Between "& Format([Enter Start Date],"long date") & " And " ...


--
Rick B

=" Between "&[Enter Start Date]&" And "&[Enter End Date]"

Where in this statement shoul I use Format()?

Can you tell me how exactly I should do it?

Thank you for the quickly reponse in this post...

Use the Format() function to display most any data type in a particular
format. Check Help if you have questions.

--
Duane Hookom
MS Access MVP
--

I already had a text box with this info: =" Between "&[Enter Start Date]&"
And "&[Enter End Date]" and it works perfectly but I would really like to
do
some format to those dates. Right now if I type 8/1 or 8/1/5 or 8/1/2005
it
shows the date as I type it.
I would like to format this to always show the date as M/D/YYYY

Thank you all!

 

[Duane Hookom]

You format() the part of your expression that you want to format...

=" Between "& Format([Enter Start Date], "m/d/yyyy") & " And " &
Format([Enter End Date],"m/d/yyyy")


--
Duane Hookom
MS Access MVP
--

=" Between "&[Enter Start Date]&" And "&[Enter End Date]"

Where in this statement shoul I use Format()?

Can you tell me how exactly I should do it?

Thank you for the quickly reponse in this post...

Use the Format() function to display most any data type in a particular
format. Check Help if you have questions.

--
Duane Hookom
MS Access MVP
--

I already had a text box with this info: =" Between "&[Enter Start
Date]&"
And "&[Enter End Date]" and it works perfectly but I would really like
to
do
some format to those dates. Right now if I type 8/1 or 8/1/5 or
8/1/2005
it
shows the date as I type it.
I would like to format this to always show the date as M/D/YYYY

Thank you all!

 

[jeannette_rivera]

Thanks Rick B. It makes me feel relax to have you all to help me. You're
great!!!

=" Between "& Format([Enter Start Date],"long date") & " And " ...


--
Rick B

=" Between "&[Enter Start Date]&" And "&[Enter End Date]"

Where in this statement shoul I use Format()?

Can you tell me how exactly I should do it?

Thank you for the quickly reponse in this post...

Use the Format() function to display most any data type in a particular
format. Check Help if you have questions.

--
Duane Hookom
MS Access MVP
--

message I already had a text box with this info: =" Between "&[Enter Start Date]&"
And "&[Enter End Date]" and it works perfectly but I would really like to
do
some format to those dates. Right now if I type 8/1 or 8/1/5 or 8/1/2005
it
shows the date as I type it.
I would like to format this to always show the date as M/D/YYYY

Thank you all!

 

[jeannette_rivera]

Thanks!!!

You format() the part of your expression that you want to format...

=" Between "& Format([Enter Start Date], "m/d/yyyy") & " And " &
Format([Enter End Date],"m/d/yyyy")


--
Duane Hookom
MS Access MVP
--

=" Between "&[Enter Start Date]&" And "&[Enter End Date]"

Where in this statement shoul I use Format()?

Can you tell me how exactly I should do it?

Thank you for the quickly reponse in this post...

Use the Format() function to display most any data type in a particular
format. Check Help if you have questions.

--
Duane Hookom
MS Access MVP
--

message I already had a text box with this info: =" Between "&[Enter Start
Date]&"
And "&[Enter End Date]" and it works perfectly but I would really like
to
do
some format to those dates. Right now if I type 8/1 or 8/1/5 or
8/1/2005
it
shows the date as I type it.
I would like to format this to always show the date as M/D/YYYY

Thank you all!

 

[Rick B]

Thanks, but Duane gets the credit for this one


--
Rick B

Thanks Rick B. It makes me feel relax to have you all to help me. You're
great!!!

=" Between "& Format([Enter Start Date],"long date") & " And " ...


--
Rick B

=" Between "&[Enter Start Date]&" And "&[Enter End Date]"

Where in this statement shoul I use Format()?

Can you tell me how exactly I should do it?

Thank you for the quickly reponse in this post...

:

Use the Format() function to display most any data type in a particular
format. Check Help if you have questions.

like
to

do
some format to those dates. Right now if I type 8/1 or 8/1/5 or 8/1/2005
it
shows the date as I type it.
I would like to format this to always show the date as M/D/YYYY

Thank you all!