HI I have a report that I want to select the current date -1.
but our dates are in this format
YYYYMMDD so I cant just use 'current date?