Date in Report/Query

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...

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" wrote:

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...
.

On Jan 7, 12:17*pm, KARL DEWEY
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.

--
Build a little, test a little.



"clk" wrote:
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.

On Jan 7, 12:17*pm, KARL DEWEY
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.

--
Build a little, test a little.



"clk" wrote:
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.

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" wrote:

On Jan 7, 12:17 pm, KARL DEWEY
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.

--
Build a little, test a little.



"clk" wrote:
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.
.

On Jan 7, 2:53*pm, KARL DEWEY
wrote:
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" wrote:
On Jan 7, 12:17 pm, KARL DEWEY
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.

--
Build a little, test a little.

"clk" wrote:
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")

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" wrote:

On Jan 7, 2:53 pm, KARL DEWEY
wrote:
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" wrote:
On Jan 7, 12:17 pm, KARL DEWEY
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.

--
Build a little, test a little.

"clk" wrote:
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")



.