Queries and Dates

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

Guest

I've got a couple fields I'm trying to pull up; they're all tied by date.

For some reason the query fails based on an input in the criteria field of
the query

such that

[Provide date:]

The table field is formatted and has an input mask set up for a short date.

I.e. in the table the date is visible as 2/25/2005

I assume in the query criteria I need to put in 02252005 or 2252005 but
neither makes the query run.

Any ideas as to why, or general pointers???

Pepe
 
Pepe,

The query criteria can be any valid date format. 02252005 or 2252005
are not valid date formats. Put your criteria in as 2/25/2005 or
2/25/05 or 2-25-05 or Feb/25/5 or.... whatever you like as long as
Access can see it's a date.
 
Access does not recognize dates in that format. 12/12/2004 is understood,
but it wouldn't know what to do with 12122004.
 
Great Seve, thanks. I'll give that a shot.

I'll give that a shot.

Thank you.

Pepe

Steve Schapel said:
Pepe,

The query criteria can be any valid date format. 02252005 or 2252005
are not valid date formats. Put your criteria in as 2/25/2005 or
2/25/05 or 2-25-05 or Feb/25/5 or.... whatever you like as long as
Access can see it's a date.

--
Steve Schapel, Microsoft Access MVP

I've got a couple fields I'm trying to pull up; they're all tied by date.

For some reason the query fails based on an input in the criteria field of
the query

such that

[Provide date:]

The table field is formatted and has an input mask set up for a short date.

I.e. in the table the date is visible as 2/25/2005

I assume in the query criteria I need to put in 02252005 or 2252005 but
neither makes the query run.

Any ideas as to why, or general pointers???

Pepe
Click to expand...
Click to expand...
 
That totally worked Steve, thanks.

Steve Schapel said:
Pepe,

The query criteria can be any valid date format. 02252005 or 2252005
are not valid date formats. Put your criteria in as 2/25/2005 or
2/25/05 or 2-25-05 or Feb/25/5 or.... whatever you like as long as
Access can see it's a date.

--
Steve Schapel, Microsoft Access MVP

I've got a couple fields I'm trying to pull up; they're all tied by date.

For some reason the query fails based on an input in the criteria field of
the query

such that

[Provide date:]

The table field is formatted and has an input mask set up for a short date.

I.e. in the table the date is visible as 2/25/2005

I assume in the query criteria I need to put in 02252005 or 2252005 but
neither makes the query run.

Any ideas as to why, or general pointers???

Pepe
Click to expand...
Click to expand...
 
Steve, thanks for the reply. Another user clued me in. I've never seen this
covered in any of my ref. books. Strange.

pepe

[MVP] S.Clark said:
Access does not recognize dates in that format. 12/12/2004 is understood,
but it wouldn't know what to do with 12122004.

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

pepenacho said:
I've got a couple fields I'm trying to pull up; they're all tied by date.

For some reason the query fails based on an input in the criteria field of
the query

such that

[Provide date:]

The table field is formatted and has an input mask set up for a short
date.

I.e. in the table the date is visible as 2/25/2005

I assume in the query criteria I need to put in 02252005 or 2252005 but
neither makes the query run.

Any ideas as to why, or general pointers???

Pepe
Click to expand...
Click to expand...
 
Back
Top