system
8
There is a topic with quite a few suggestions for date objects as a “sticky” in this forum. Try having a look there first.
If that topic doesn’t help, you need to post which database you’re connecting to as the functions are not the same for every vendor.
Dave Rathbun 
(BOB member since 2002-06-06)