Query Date Output Fomatting Problem

[CSHANKY]

I have a table with 3 fields:

1. [del_complete] is a yes/no field
2. [due_dt] is a date field, medium date format
3. [status] is a text field


I created a query using the 3 fields and added "X" which is a calculated field and coded it as:

X: IIf([del_complete]=-1,"Complete",[due_dt] & " " & [status])

I would like to know what modification I should make to the code above so that [due_dt] output is displayed in medium date format (e.g. 23-Jan-04) in the "X" field, when relevant. Currenty it shows mm/dd/yy (e.g. 01/23/04).

Thanks a LOT to the forum folks for their help !


Example:

NOW
----

del_complete due_dt status X
------------ ----- ------ ------
Yes 12-Dec-03 howdy Complete
No 01-Jan-94 hello 1/1/04 hello


I WOULD LIKE
------------

del_complete due_dt status X
------------ ----- ------ ------
Yes 12-Dec-03 abc Complete
No 01-Jan-94 def 01-Jan-04 hello

 

[dhookom]

Dates are always stored in the exact same way as every other date in every MDB, in every language. It is simply a floating point number containing the number of days (and partial days) since Dec 30, 1899. Try this expression:
X: IIf([del_complete]=-1,"Complete",Format([due_dt],"dd-mmm-yy&quot & " " & [status])

Duane
MS Access MVP
Find out how to get great answers faq219-2884.