ordering by date

[bongmarley]

I am trying to order people from a database based on their date of birth.

so the code is like this

("select * from tablename order by birthdate&quot

However the birthdate field is of type text so i have to use the cdate() function. This works good however the field is not required so it can contain a Null value. The cdate() function can not be used on a Null value. It just gives me an error. Is there any way to get around this

 

[JamesLean]

Yes, change the datatype of your column to datetime!! Is there any reason it was not set up like this?

You could work round it but it will be much easier if you can change the type. --James

 

[bongmarley]

Changing the datatype is not an option based on a lot of factors.

 

[JamesLean]

What DB are you using and what format are the char dates in, eg dd/mm/yyyy? --James

 

[vbkris]

you dont have to do so much
if DtValueFromDb<>&quot;&quot; then
cdate(DtValueFromDb)...
end if