Last day of last year

  • Thread starter Thread starter Saskatoon
  • Start date Start date
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
 
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)
 
-----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...
 
Back
Top