date format for ODR_DATE question

[malaize_(Guest)]

Hi,____I am trying to use a query in a report so I can sort by the ODR_DATE.__ODR_DATE is an 8 character Date field so I tried using 01/01/05 in the "compared to" field but when I click ok I receive a message saying: "Date Required". I also tried putting double quotes around the date.____Does anyone know if xx/xx/xx is the proper way to write date fields for ODR_DATE?____Thanks, malaize____R&R 9

[kfleming]

{01/01/2005}

[malaize_(Guest)]

Thank you very juch kfleming!__Just what I was looking for.______malaize