Date in Report/Query

C

clk

Hi. I have a report that has worked up until this past week. The
query behind the report has the following expression:

DateAuth: Format([CredAuthDate],"mm/dd/yy")

If I type in 12/31/09....report works fine. Type in anything with
"10" as the year and it fails.

Any suggestions would be greatly appreciated. If I take off the
format for the field it works. Is something different for the year
2010?

This is an Access 2003 database.

Thanks...
 
K

KARL DEWEY

I suggest applying criteria to an 'unformatted' field and turn off the
display by unchecking the 'Show' check box.

For further explaination post the exact criteria you used that worked and
did not work.
 
C

clk

I suggest applying criteria to an 'unformatted' field and turn off the
display by unchecking the 'Show' check box.

For further explaination post the exact criteria you used that worked and
did not work.

--
Build a little, test a little.



clk said:
Hi.  I have a report that has worked up until this past week.  The
query behind the report has the following expression:
DateAuth: Format([CredAuthDate],"mm/dd/yy")
If I type in 12/31/09....report works fine.  Type in anything with
"10" as the year and it fails.
Any suggestions would be greatly appreciated.  If I take off the
format for the field it works.  Is something different for the year
2010?
This is an Access 2003 database.
Thanks...
.- Hide quoted text -

- Show quoted text -

Sorry....I did miss adding the criteria.
=[Authorized since: Date Format mm/dd/yy]

The above is the criteria to prompt for the date. If I type in
12/31/09 (or prior to that date) it works fine. If I type 1/1/10 or
beyond it doesn't work.

I will try what you suggested. Thank you.
 
C

clk

I suggest applying criteria to an 'unformatted' field and turn off the
display by unchecking the 'Show' check box.

For further explaination post the exact criteria you used that worked and
did not work.

--
Build a little, test a little.



clk said:
Hi.  I have a report that has worked up until this past week.  The
query behind the report has the following expression:
DateAuth: Format([CredAuthDate],"mm/dd/yy")
If I type in 12/31/09....report works fine.  Type in anything with
"10" as the year and it fails.
Any suggestions would be greatly appreciated.  If I take off the
format for the field it works.  Is something different for the year
2010?
This is an Access 2003 database.
Thanks...
.- Hide quoted text -

- Show quoted text -

Your suggestion worked. I am curious why the report worked prior to
01/01/10. Seems odd.

Well...I appreciate the help. Thank you.
 
K

KARL DEWEY

I guess you did not want further explaination and that is why you did not
post the exact criteria you used that worked and did not work.

--
Build a little, test a little.


clk said:
I suggest applying criteria to an 'unformatted' field and turn off the
display by unchecking the 'Show' check box.

For further explaination post the exact criteria you used that worked and
did not work.

--
Build a little, test a little.



clk said:
Hi. I have a report that has worked up until this past week. The
query behind the report has the following expression:
DateAuth: Format([CredAuthDate],"mm/dd/yy")
If I type in 12/31/09....report works fine. Type in anything with
"10" as the year and it fails.
Any suggestions would be greatly appreciated. If I take off the
format for the field it works. Is something different for the year
2010?
This is an Access 2003 database.
Thanks...
.- Hide quoted text -

- Show quoted text -

Your suggestion worked. I am curious why the report worked prior to
01/01/10. Seems odd.

Well...I appreciate the help. Thank you.
.
 
C

clk

I guess you did not want further explaination and that is why you did not
post the exact criteria you used that worked and did not work.

--
Build a little, test a little.



clk said:
I suggest applying criteria to an 'unformatted' field and turn off the
display by unchecking the 'Show' check box.
For further explaination post the exact criteria you used that workedand
did not work.
--
Build a little, test a little.
:
Hi.  I have a report that has worked up until this past week.  The
query behind the report has the following expression:
DateAuth: Format([CredAuthDate],"mm/dd/yy")
If I type in 12/31/09....report works fine.  Type in anything with
"10" as the year and it fails.
Any suggestions would be greatly appreciated.  If I take off the
format for the field it works.  Is something different for the year
2010?
This is an Access 2003 database.
Thanks...
.- Hide quoted text -
- Show quoted text -
Your suggestion worked.  I am curious why the report worked prior to
01/01/10.  Seems odd.
Well...I appreciate the help.  Thank you.
.- Hide quoted text -

- Show quoted text -

I did post the criteria. Below is the only criteria used in the
query:
=[Authorized since: Date Format mm/dd/yy]

This criteria is used on the following field:

DateAuth: Format([CredAuthDate],"mm/dd/yy")
 
D

Duane Hookom

This is a date:
=[Authorized since: Date Format mm/dd/yy]

This is a string:
DateAuth: Format([CredAuthDate],"mm/dd/yy")

--
Duane Hookom
Microsoft Access MVP


clk said:
I guess you did not want further explaination and that is why you did not
post the exact criteria you used that worked and did not work.

--
Build a little, test a little.



clk said:
On Jan 7, 12:17 pm, KARL DEWEY <[email protected]>
wrote:
I suggest applying criteria to an 'unformatted' field and turn off the
display by unchecking the 'Show' check box.
For further explaination post the exact criteria you used that worked and
did not work.
:
Hi. I have a report that has worked up until this past week. The
query behind the report has the following expression:
DateAuth: Format([CredAuthDate],"mm/dd/yy")
If I type in 12/31/09....report works fine. Type in anything with
"10" as the year and it fails.
Any suggestions would be greatly appreciated. If I take off the
format for the field it works. Is something different for the year
2010?
This is an Access 2003 database.
Thanks...
.- Hide quoted text -
- Show quoted text -
Your suggestion worked. I am curious why the report worked prior to
01/01/10. Seems odd.
Well...I appreciate the help. Thank you.
.- Hide quoted text -

- Show quoted text -

I did post the criteria. Below is the only criteria used in the
query:
=[Authorized since: Date Format mm/dd/yy]

This criteria is used on the following field:

DateAuth: Format([CredAuthDate],"mm/dd/yy")



.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top