IIF statement using a date

[elegant]

I have a date field in a table and i want to write an IIf statement in a query wizard using that date to get another date field.

The date field i already have in one of the tables is SaleDate. i need for the IIF statement to give me First day of the month that the file goes to sale (will always be mm/dd/yyy format)

Lets just say the saledate is 05/09/2011 i need the iif statement to give me 05/01/11. Its always the first day of the saledate month

I would start the iff statement with this IIf[SaleDate] ---but then i dont know the rest of it.

If anyone can help me it would be greatly appreciated.

Thank you.

[pbaldy]

I don't think you want an IIf(), you want DateSerial(). Use the Month() and Year() functions with your sale date and hard-code the day argument to 1.