B
Bob V
Only records that are 3 years old, <1095 days Is this possible Thanks for
any help....Bob
any help....Bob
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.
B
Bob V
This does not work because Date field is Text <Date()-"1095" Thanks for any
help..Bob
help..Bob
J
John W. Vinson
This does not work because Date field is Text <Date()-"1095" Thanks for any
help..Bob
What are the contents of this misnamed Date field? Text that looks like a
date? a number? or what?
John W. Vinson [MVP]
B
Bob V
Thanks John, it is [DateNo] and its is a text field so as I can display it
to look like this on a form 25-Dec-07
thanks Bob
to look like this on a form 25-Dec-07
thanks Bob
J
John W. Vinson
Thanks John, it is [DateNo] and its is a text field so as I can display it
to look like this on a form 25-Dec-07
Do you also have a Date/Time field in the table? If so, you can simply display
IT using dd-mmm-yy as the format of a form textbox. There is NO need to store
date information in a text field, and (since Access won't recognize it as a
date) every reason not to do so!
John W. Vinson [MVP]
B
Bob V
Thanks John, Change the field to Date/Time Great...Bob
John W. Vinson said:Thanks John, it is [DateNo] and its is a text field so as I can display it
to look like this on a form 25-Dec-07
Do you also have a Date/Time field in the table? If so, you can simply
display
IT using dd-mmm-yy as the format of a form textbox. There is NO need to
store
date information in a text field, and (since Access won't recognize it as
a
date) every reason not to do so!
John W. Vinson [MVP]