A quick question about Date format

[Anna_Guo]

My date format is YYMMDDN8., I would like t select the date range between 20080912 and 20080917. I tried various ways, but none worked.

Thank you for your help!

[Reeza · Accepted solution]

where date between '12Sep2008'd and '17Sep2008'd;

You need a date literal.

[Anna_Guo]

Reeza,

Thank you for your help. /Anna