Expression for first & last day of last year

[Andrew Thorpe]

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]

Hi. Have you tried?

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

and

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

 

[isladogs]

A very slightly different method for the final day of last year:

DateSerial(Year(Date),1,0)

 

[Andrew Thorpe]

Yes. That works too. Many thanks.

 

[Andrew Thorpe]

Hi. Have you tried?

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

and

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

Fantastic. That works perfectly. Thank you.

 

[theDBguy]

Fantastic. That works perfectly. Thank you.

Hi Andrew,
You're welcome. Colin and I were happy to assist. Good luck with your project.