Date Problem

[Guest]

I want the field in a query to display the date: #8/1/Year(date())#
obviously this does not work or I would be using it but you get the idea.

Any thoughts?

 

[Guest]

Try:

"8/1/" & Year(Date())

 

[Guest]

in the field cell in the design view right click to properties and then go to
format (long date, short date etc)

 

[John Spencer]

Try
DateSerial(Year(Date()),8,1)