Hi,

I'm using ASP and an Access Database for a project. I need to use a timestamp field, but if I mark the field Date/Time, I get an error message (Data mismatch). How can I use a text field with Now() but have it grab only the day date and not the time.

Example: 2/26/2006 instead of 2/26/2006 11:34:00am

Thanks for your help...you guys are awesome! :)

Why would you use a text field to hold a date. Use a date type data field and insert date() for just the date - dont forget to use the # around your dates in your statement

Wind is your friend
Matt

If I mark the field as a date, when pulling the field for an .asp page, I get a "data mismatch" error. Apparently this is a problem with Access/.asp per Microsoft. They suggested using a text field. Is there any way to create the timestamp using only the date portion, and not the time without using a date/time field type? OR I have a timestamp field, can I create a new field from it pulling only the date (2/26/2006) portion?

Thanks!

I use date/time but insert only the date. I am not aware of such a problem. What date format do you use? I use and insert dd/mm/yyyy

on insert run this function:

  FUNCTION auDate(varDate)
    IF isNull(varDate) OR Trim(varDate) = "" OR varDate = "Null" THEN
      auDate = "Null"
    ELSE
      auDate = "" & Day(DateValue(varDate)) & "/" & Month(DateValue(varDate)) & "/" & Year(DateValue(varDate)) & ""
    END IF
  END FUNCTION

INSRT INTO tbleName (dateField)VALUES('#" & auDate(myDatevar) & "
#');"



Wind is your friend
Matt