Member Avatar for spidey

hi,

i have a popup which asks for a date. when clicked, it will close and display the records created on that date on a new page. the format passed is d/m/yyyy.

a portion of my sql is as follows: sqls=sql&" WHERE pr.DateCreated LIKE '" & datec & "'" where: datec = request("datec") the problem is that it only display those records with double-digit day and/or month (e.g., 24/12/2005 and 10/11/2006) in DateCreated field in the database. It does not display records with DateCreated field having a single-digit day and/or month (e.g., 4/12/2005, 3/5/2005 and 11/7/2005).

in ms access database, the data type of DateCreated field is date/time and has a format of d/m/yyyy.

why is that so? i need it very badly.:cry:

pls, help me. :sad: i wud very much appreciate it.

thank u in advance. :o

  • 1 Contributor
  • 1 Reply
  • 67 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by spidey
Member Avatar for spidey

hi again,

i just found the solution. thnks anyway. :)

have a nice day!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.