format expression field in query as a date 1

[Lost500]

I have a expression in a query Nz([fieldname],[fieldname]). it runs fine but the results in that field are not formated as a date. (both fields are dates themselves) how can i tell access to format the results as a date field? any help would be great!

 

[Lost500]

So im trying stuff like Format(Nz([fieldname],[fieldname]), "mm/dd/yyyy" the query runs but when i try to sort the field it doesn't pick it up as a date. ultimatley i want to be able to sort by date. any advice??

 

[dhookom]

Try:

  CDate(Nz([fieldname],[fieldname]))

or

  DateValue(Nz([fieldname],[fieldname]))

Duane
Hook'D on Access
MS Access MVP

 

[Lost500]

Thanks dhookom!! CDate() worked great though i cant have any null values!