[AccessD] BoY() and EoY() functions

Gustav Brock gustav at cactus.dk
Wed Sep 1 13:48:39 CDT 2004


Hi Arthur

BoY() is DateSerial(Year(datDate), 1, 1)
EoY() is DateSerial(Year(datDate) + 1, 1, 0)

They should really returns date/time values.
The format is up to you.

/gustav


> I was positive that I had written these, but can't seem to find them.
> BoY() accepts a date and returns the beginning of the year. EoY()
> accepts a date and returns the end of the year. They must accept any
> international system settings and return the desired dates in the same
> format.




More information about the AccessD mailing list