Howto create derivedtable for sysdate,sysdate-1 in Designer?

Another option is to just create relative date objects, as described in this sticky topic.

Regard,s
Mark