Date Field Question

Results 1 to 2 of 2

Thread: Date Field Question

  1. #1
    Join Date
    Dec 1969

    Default Date Field Question

    I have a DateDue field in my access database and I need to be able to find all records with a Date prior to the current date in this field. if I set the field property to &#039;Date/time&#039; and use the following Where statement<BR>WHERE DateDue &#060; Date()<BR>Everything works.<BR>Now the problem.<BR>Sometimes I need to enter the text "unknown" for the date.<BR>If I change the properties of the DateDue field to &#039;Text&#039;<BR>then the WHERE statement no longer returns the proper records.<BR>Any ideas?

  2. #2
    Join Date
    Dec 1969

    Default RE: Date Field Question

    WHen you make it as text you will need to convert it to Date type in the SQL statement.<BR><BR>Try using the Convert function:<BR><BR>Convert(datetime, DateDue)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts