Last day of last year

S

Saskatoon

I would like to have an expression field in a query return
the last day of the previous year.I don't want to have to
edit my queries from 12/31/03 to 12/31/04 next January.
Could you use DatePart? somehow?
Thanks in advance.
Saskatoon
 
R

Rick Brandt

Saskatoon said:
I would like to have an expression field in a query return
the last day of the previous year.I don't want to have to
edit my queries from 12/31/03 to 12/31/04 next January.
Could you use DatePart? somehow?
Thanks in advance.
Saskatoon
Click to expand...

DateSerial(Year(Date())-1,12,31)
 
S

Saskatoon

-----Original Message-----
I would like to have an expression field in a query return
the last day of the previous year.I don't want to have to
edit my queries from 12/31/03 to 12/31/04 next January.
Could you use DatePart? somehow?
Thanks in advance.
Saskatoon
.
Thanks for the reply Rick
Click to expand...
 
Top