Expression for first & last day of last year (1 Viewer)

Andrew Thorpe

Registered User.
Local time
Today, 00:27
Joined
Apr 18, 2009
Messages
59
An expression to get the last day of this year is DateSerial(Year(Date()),12,31) but I am trying to figure out expressions for both the First Day and the Last Day of LAST year. This is so that I can prepare queries for sales info etc for the whole of last year.
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 17:27
Joined
Oct 29, 2018
Messages
21,358
Hi. Have you tried?

DateSerial(Year(Date)-1,1,1)

and

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

isladogs

MVP / VIP
Local time
Today, 00:27
Joined
Jan 14, 2017
Messages
18,186
A very slightly different method for the final day of last year:

DateSerial(Year(Date),1,0)
 

Users who are viewing this thread

Top Bottom