When I "execute immediate" it is necessary to use a double quoted string for the date

Code:
''YYYYMMDD''