Thank you, Stella! Simple and ingenious solution and I was afraid that I'll end up writing complicated routine. This statement gives the desired date: PADL(YEAR(DATE())-1900, 3, "0")+PADL(DATE(YEAR(DATE()), MONTH(DATE()), DAY(DATE()))-DATE(YEAR(DATE()),1,1),3,"0")