Hi everyone, dateadd("d",-1,date()) this doesn't work dateadd("d",-1,#13-9-2004#) this works great But i need the first solution. I always need the date of yesterday Can somebody help me!!