JQL

Get the yesterday issues;

project = "DUMMY" AND created >= -2d AND created < -1d ORDER BY created DESC